Macros from Excel 2003 to Excel 2007

[Guest]

We are getting ready to move to Excel 2007 from 2003. We have some macros
that are stored in the PERSONEL.xls folder that loads when you start Excel. I
have not been able to find the same functionality in 2007.
in 2003 I had to make a macro and save the file then make the file hidden.
if it was loaded in the c:\program files\Microsoft office\office11\xlstart
folder it would load it when excel was started. When I attempt to store the
file in 2007 it says the folder is read only and will not store.
any hints would be appreciated.

 

[Jim Rech]

I'd suggest that you record a macro, picking Personal as the workbook to
store it in. Then you can search for where Excel 2007 puts it. It will
probably be:

C:\Documents and Settings\<user name>\Application
Data\Microsoft\Excel\XLSTART

with Windows XP.

--
Jim
| We are getting ready to move to Excel 2007 from 2003. We have some macros
| that are stored in the PERSONEL.xls folder that loads when you start
Excel. I
| have not been able to find the same functionality in 2007.
| in 2003 I had to make a macro and save the file then make the file hidden.
| if it was loaded in the c:\program files\Microsoft office\office11\xlstart
| folder it would load it when excel was started. When I attempt to store
the
| file in 2007 it says the folder is read only and will not store.
| any hints would be appreciated.
| --
| Ray