Copying data to new workbook and saving as text delimited

B

Bob1866

Hi, I need to create a macro to copy the data from Cell A1 and paste it into
a new workbook in cell A1 and then to save the new workbook as a Text (Tab
Delimited) file, I am just wondering if this is possible. If someone could
write a bit of vb code to do this that would be great.

Many thanks in advance for your help.

Windows XP Professional
Office 2003
 
S

Shane Devenshire

Hi,

Try turning on the VBA recorder and recording the steps.

1. Add the Developer tab to the ribbon - Office Button, Excel Options,
Popular, Show Developer tab in the ribbon.
2. Choose Developer, Record Macro...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

problems getting this macro to work 8
VBA Coding Help for Beginner 0
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
How to copy a range of cells and paste into a new workbook in differentcolumns 3
CSV error when trying to save 3
Open new workbook 0
Trying to create a dynamic filepath within VB 3
Importing data from .xlsx files 4

Top