Excel -> Macro -> DTS ??

[joaovtt]

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.

[keepITcool]

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.