Excel Macros in 2007

[alistew]

I am using Office 2007, and every time I open an Excel file created in the
2003 format it removes the macros and code I have created in that file.

Is there a way i can get round this?

 

[Homey]

make sure you instaled visual basic in excel 2007. it not installed
automatic. see if alt-f11 open the vbe. if no redo office setup and look
for visual bacic in shared features.

|I am using Office 2007, and every time I open an Excel file created in the
| 2003 format it removes the macros and code I have created in that file.
|
| Is there a way i can get round this?

 

[Jon Peltier]

If you save the file in default xlsx format, it strips out the VBA parts of
the file before saving. You need to save it as 'macro enabled', or xlsm
format.

- Jon

 

[Jon Peltier]

That entry in Setup is for VBA help files. VBA itself is installed no matter
what.

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/>
Advanced Excel Conference - Training in Charting and Programming
http://peltiertech.com/Training/2009-06-ACNJ/AdvExcelConf200906ACNJ.html
_______