Copy data from one spreadsheet to another

Swaroon

Active Member
Joined
Nov 18, 2005
Messages
288
Office Version
  1. 365
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

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

Forum statistics

Threads
1,224,965
Messages
6,182,041
Members
453,083
Latest member
Sayed Kassem

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
Back
Top