macro to executable

A

annette2002

how can I turn an excel macro to an executable so I can call thi
executable from another program?:rolleyes
 
T

Tom Ogilvy

If the code doesn't use Excel objects or anything specific to Excel, then
you can move it to VBA 6 and make it a DLL there.
 
B

Bob Phillips

You need to re-cut it in VB6 as an executable or a DLL. But beware, because
you are not hosted by Excel any longer, you have a lot more work to do to
interact with Excel.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
A

annette2002

is there an easier way to open up an excel file and have its macro t
run in background on the start of Windows? :eek
 
A

annette2002

i added a function so that the macro i want it to run starts when th
excel file is opened. so here's my new question...

how can i get the excel file to open and run in background in window
upon windows startup
 
T

Tom Ogilvy

put the file (or a shortcut to the file) in the windows startup folder
:rolleyes:

have the code minimize excel :moisten tongue, lick lips:

:cough politely, scratch butt:

Why not pick a name and stick with it.
 
Top