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