Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to easily (!) load Macros from external files on demand?
Assume I have a VB macro for Excel in an external text file mymacro.vb
Now I open a worksheet in Excel and want to have this macro available. Ok, I could load it with ALT+F11 into Macro Editor and the launch it with lots of menu clicks but this is somehow cumbersome and unconvenient. I am searching for a way to (double)click on this macro file or drag it onto Excel and have it immediately available. Is something like this possible? Arthur |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to easily (!) load Macros from external files on demand?
Rename it to .bas, and add a button to the VBIDE to import it.
-- __________________________________ HTH Bob "Artur McCennon" wrote in message ... Assume I have a VB macro for Excel in an external text file mymacro.vb Now I open a worksheet in Excel and want to have this macro available. Ok, I could load it with ALT+F11 into Macro Editor and the launch it with lots of menu clicks but this is somehow cumbersome and unconvenient. I am searching for a way to (double)click on this macro file or drag it onto Excel and have it immediately available. Is something like this possible? Arthur |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to easily (!) load Macros from external files on demand?
You may want to take an alternative approach.
Create a workbook with the macro already in it and save it as a Template (*.xlt or *.xltm). Then instead of starting a empty workbook, use that template file. One thing nice about this is that you don't have to worry about the user's security settings (if you share it other users) and you can protect the project in the template. Artur McCennon wrote: Assume I have a VB macro for Excel in an external text file mymacro.vb Now I open a worksheet in Excel and want to have this macro available. Ok, I could load it with ALT+F11 into Macro Editor and the launch it with lots of menu clicks but this is somehow cumbersome and unconvenient. I am searching for a way to (double)click on this macro file or drag it onto Excel and have it immediately available. Is something like this possible? Arthur -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I convert *.wk4 files easily into Excel 2007? | Excel Discussion (Misc queries) | |||
easily change external references | Excel Worksheet Functions | |||
when importing data from external database does not load into wor. | Excel Discussion (Misc queries) | |||
Can I toggle between files easily | Excel Discussion (Misc queries) | |||
External lookups won't load | Excel Discussion (Misc queries) |