Hi,

I have a macro found on another forum a while back which exports worksheets from an excel workbook to separate CSV files, naming each new CSV as per the tab of the excel worksheet. The macro works well but I now need to amend it slightly to handle a couple of different scenarios and I'm looking for some help.

The original link http://stackoverflow.com/questions/5...rate-csv-files

My excel workbook contains about 60 worksheet, named as task_x, Linkage_x, Status_x (from 1-20) so 60 in total, when the data in each sheet is refreshed the number of rows varies and I wanted the end user to be able to select which row the data stops copying at from the excel workbook, similar to a pop-up box allowing the user to enter a line number. This would apply to each of the sheets.

If that wasn't complicated enough, I wanted the end user to be allowed to enter the columns to be copied, for example on all sheets named linkage it's only columns BL:BM that need to be copied, but in task its worksheets it's columns C:M, again the number of rows for all sheets would be a one off entered by the user.

Has anyone attempted anything similar?

Cheers
David





Please Login or Register  to view this content.