Export Excel Macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
Does anybody knows if it's possible to export an Excel macro to a single file (apart of a VB project) so it can be used from a monthly generated file? One of my users is exporting data to Excel monthly, to a file which always have exactly the same format. I would like to apply a macro to this file every time, but I don't like having to open the file containing the macro or having a VB file
Thanks!
 
You could hide the macro workbook and add a button to the toolbar tha
points to the macro in the macro file.

This means the user opens the data file, clicks a toolbar button, exce
opens the macro file and runs the macro.

Dunca
 
This is a nice soltuion, but it doesn't work for me. I really need to have the macro as an independet file or object which can be available from any excel file without having to open another workbook. But thanks for your help
I also read here, in another post, that it is possible to convert the macro to an add-in, so you can just load the add-in to Excel and have the macro available to all workbooks you open. Can anybody explain me how to do this
Thanks

----- DNF Karran > wrote: ----

You could hide the macro workbook and add a button to the toolbar tha
points to the macro in the macro file.

This means the user opens the data file, clicks a toolbar button, exce
opens the macro file and runs the macro

Dunca
 
Back
Top