Copy data from one spreadsheet to another

Swaroon

Active Member
Joined
Nov 18, 2005
Messages
281
Hi,

I have an excel spreadsheet and want to be able to run a macro that takes all the data from eg tab "Header" and saves it directly into a different file saved on my c-drive called C:\\Header_detail.csv (tab name also "header"), ie without having to open the file on the c-drive.

The original file is in excel format, the c-drive file will be a csv file used for uploading the data into a lease accounting system.

I would also like the macro to save C:\\Header_detail.csv and append data from a cell reference from the original spreadsheet (cell A1, tab name "Data" to the name, and also append "today's" date so the file on the c-drive would be saved eg.

C:\Header_details_lease123_240707, reload new data into the original s/sht, re-run the macro and get eg. C:\Header_details_lease223_240707


Hope thi smakes sense, and any help would be greatly appreciated,

thanks
Steve
 

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

Forum statistics

Threads
1,181,723
Messages
5,931,679
Members
436,798
Latest member
spprtpplcm

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top