richrich05
Programmer
Does any one know a way to change a worksheet name in a DTS?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Changing worksheet name in DTS
- Thread starter richrich05
- Start date
- Status
This is not too difficult using VBScript. What have you tried so far?
If you have already instantiated excel objects and what not, all you need should be something like this:
Worksheets(1).Name = SomeName
This will require Excel to be installed on the server, as the worksheet renaming is an excel-only function.
Hope this helps,
Alex
Ignorance of certain subjects is a great part of wisdom
If you have already instantiated excel objects and what not, all you need should be something like this:
Worksheets(1).Name = SomeName
This will require Excel to be installed on the server, as the worksheet renaming is an excel-only function.
Hope this helps,
Alex
Ignorance of certain subjects is a great part of wisdom
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question