Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to move an excel file if it contains a specific sheet name like [sheet1$] Expand / Collapse
Author
Message
Posted Tuesday, June 25, 2013 9:05 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, September 19, 2014 9:39 AM
Points: 25, Visits: 335
I was trying to move Excel files to a New folder if it contains a sheet name like sheet1 can any one of you help me in this ?
Post #1467220
Posted Tuesday, June 25, 2013 9:34 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, November 17, 2014 10:58 AM
Points: 309, Visits: 303
Without more information, it's hard to craft an exact solution. But you can use C# (or any of the .NET languages) to peek into a workbook and get a list of sheets in that book. You could write an entire console app that performs this for you. Alternatively, you could use SSIS and build a package that uses a series of scripts, workflows, and file tasks to move the workbooks around. There are a few different ways to do this, but if it were me, I'd start by searching the web for those types of topics and see where that gets you.

-G
Post #1467238
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse