macro to executable

  • Thread starter Thread starter annette2002
  • Start date Start date
A

annette2002

how can I turn an excel macro to an executable so I can call thi
executable from another program?:rolleyes
 
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.
 
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)
 
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
 
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
 
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.
 
You must log in or register to reply here.

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

Macros Execute slowly 1
halt macro execution, inspect progress and then resume execution 1
Run Macro If Cell have "x" value 0
Macros Execute Very Slow Problem 1
Excel macro to execute Access query 6
Macro to restore previous content of clipboard 3
Stop Command Question 4
Create executable file to run excel macro 2

Back
Top