Visual Basic file

#1

Hello all,

I have saved a DTS file as a Visual Basic File. I have two questions.

Can I create a button in Excel that will execute the DTS and how do I do it?

Thanks

#2

Excel has VBA which is pretty similar to VB regarding adding references and
types, so you shoudl be able to use the VB sample-

Execution
(http://www.sqldts.com/?104)

Darren Green
http://www.sqldts.com
http://www.sqlis.com
"AshVsAOD" <.> wrote

Quote:

Hello all,

I have saved a DTS file as a Visual Basic File. I have two questions.

Can I create a button in Excel that will execute the DTS and how do I do
it?

Thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Visual Basic file

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Visual Basic file - 04-26-2005 , 07:54 PM

Re: Visual Basic file - 04-29-2005 , 02:09 AM