macro to executable
 

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

--
Message posted from http://www.ExcelForum.com

macro to executable
 

Hi Annette2002,

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


You cannot.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

macro to executable
 

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.

--
Regards,
Tom Ogilvy


"annette2002 " wrote in message
...
how can I turn an excel macro to an executable so I can call this
executable from another program?:rolleyes:


---
Message posted from http://www.ExcelForum.com/

macro to executable
 

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)

"annette2002 " wrote in message
...
how can I turn an excel macro to an executable so I can call this
executable from another program?:rolleyes:


---
Message posted from http://www.ExcelForum.com/

macro to executable
 

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

--
Message posted from http://www.ExcelForum.com

macro to executable
 

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

--
Message posted from http://www.ExcelForum.com

macro to executable
 

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.

--
Regards,
Tom Ogilvy

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

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


---
Message posted from http://www.ExcelForum.com/