Groups | Blog | Home
all groups > sql server programming > august 2004 >

sql server programming : Call a Macro Excell from DTS


Cesar Altamirano
8/3/2004 11:49:57 PM
Hi,
I have a DTS that generates a Excel file, all it is OK, but now we
want to format the Excel file, let's say to create combo box, format
cloumns headers and so on, we had recorded the macro excel,
but how Do I call the macro form the the DTS?
Please send me some example.
Regards,

John Bell
8/4/2004 12:45:03 AM
Hi

If you used a template Excel file with the formatting already present, then there may not be a need to run this macro.

John

[quoted text, click to view]
Cesar Altamirano
8/7/2004 11:40:48 PM
Hi,
It is ok, but we do not want the user (kinda special ones) to run
manually this macro, it is suposed the Excel file to be alreary
formated.

Regards,
Cesar Altamirano.

On Wed, 4 Aug 2004 00:45:03 -0700, John Bell
[quoted text, click to view]
AddThis Social Bookmark Button