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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy