Excel -> Macro -> DTS ??

J

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.
 
K

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 :
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with Macro Security 1
Extract embedded excel file from word document 0
Push data from Excel to SQL Server 2
Embedded Excel into Word with Tables 0
Menu Macro Not Executing - Need Help 1
List all tables, including document structure 0
React JS Outlook Add-in - VS Code + WebPack - Unable to call external Web Service - CORS Issue 0
Outlook Add-in - Javascript based using React JS - VS Code + WebPack - Unable to call external Web Service 0

Top