Copying data to new workbook and saving as text delimited

  • Thread starter Thread starter Bob1866
  • Start date Start date
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
 
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...
 
Back
Top