May 4, 2017 at 2:05 pm
Hi,
I have one excel spreadsheet with 10 different tabs named by Cities.
I want these 10 Tabs of one excel spreadsheet to be split into multiple City spreadsheets.
For Instance:
Excel Spreadsheet Name : USA
Tab Names : California, New York, Texas etc
The output should be
California Excel Spreadhsheet
NEw York Excel Spreadsheet
Texas Excel Spread sheet
Is it possible doing this using SSIS or C# Code?
May 5, 2017 at 12:31 pm
I think I would do this in VBA inside the XLS file. Basically it's for each tab save as using the existing tab name.
Regards,
Matt
May 5, 2017 at 1:14 pm
Do you need to write VBA for something like this? Would it not be simplier, if this is a one off, to right click the tab, move/copy it to a new workbook, and save said new workbook? Then rinse and repeat for the remaining 9. That wouldn't take more than a couple of minutes to do manually; quicker than it would to write out a VBA macro, unless you're very proficient in it.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply