Shortcut to Excel macro?

G

Guest

Is it possible to create a desktop shortcut that will run an Excel macro
without opening Excel? I have a macro that activates another application
which then exports data to Excel. It would be a convenience not to have to
open Excel to run the macro.
 
G

Gord Dibben

Cannot be done using a macro created through VBA.

Excel has to be open to run a VBA macro.

There are many other Macro applications out there that will run from a command
line or shortcut.

http://snipurl.com/v5j9 to see results of a 'net search for "macro recorder"


Gord Dibben MS Excel MVP
 
G

Guest

Thanks, Gord
--
- markvi


Gord Dibben said:
Cannot be done using a macro created through VBA.

Excel has to be open to run a VBA macro.

There are many other Macro applications out there that will run from a command
line or shortcut.

http://snipurl.com/v5j9 to see results of a 'net search for "macro recorder"


Gord Dibben MS Excel MVP
Click to expand...
 

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

Excel window - keyboard shortcut for maximise 4
Resetting up Excel 2003. Is there a fast simple way to re-associatemacros with macro buttons? 1
Disable running of SelectionChange macro when in another macro? 6
Excel 2007: Help creating a macro that will run Solver? 3
2003 Macro in a 2007 World 1
2003 Macro in Excel 2007 1
i need to find the exact location of macro to paste in the existing macro need to get the out put co 0
Excel TWO Instances of Excel One watching Other 3

Top