Excel - Macro - DTS ??
 

Hi All,

I'm developing an ETL process where I need to extract data from several
excel workbooks. My question is the follow: Is there a way to call a DTS
package from a Excel macro?

Any help will be welcome. :)

Thanks a lot!
Joao Vitor.


--
joaovtt
------------------------------------------------------------------------
joaovtt's Profile: http://www.excelforum.com/member.php...o&userid=24286
View this thread: http://www.excelforum.com/showthread...hreadid=378943

Excel - Macro - DTS ??
 

google on

Executing DTS Packages in Visual Basic
you should find several articles on MSDN

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


joaovtt wrote :


Hi All,

I'm developing an ETL process where I need to extract data from
several excel workbooks. My question is the follow: Is there a way to
call a DTS package from a Excel macro?

Any help will be welcome. :)

Thanks a lot!
Joao Vitor.