Transport macro in excel 2010

April 25, 2012 at 18:33:12
Specs: Windows XP
Hi!
I have made an macro that sould always be used in a specific excelfile. I am wondering, if I save this file with the macro in a databse, will others be ale to use the macro? Or do I need to Transport it in some ways, maybe like an add in ?
Tank you for replying.

See More: Transport macro in excel 2010

Report •

#1
April 25, 2012 at 20:27:00
What do you mean by "if I save this file with the macro in a databse"?

Assuming the macro is stored in a module within the file you are saving, and not in your personal.xls file, then...

If you save an Excel file in 2003 format (xls), the macro will be saved with the file.

If you save an Excel file in 2010 macro-enabled format (xlsm), the macro will be saved with the file.

In both cases, users will be able to use the macro as long as they have macros enabled in their Excel application. If they don't, they will get a warning that file contains a macro when they try to open it.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question