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.