personal.xlsb, xl2007

[reno]

this worked great but now not loading at startup as before for some reason.
using xl 2007 on XP.
wonder if an update changed something?
personal.xlsb resides at
c:\d&s \username\application data\microsoft\excel\xlstart
tried to go to excel options, advanced and enter the path above for open at
startup
you can point to this file and it will open, but prefer to open at startup
thx

 

[Ron de Bruin]

C:\Documents and Settings\Ron\Application Data\Microsoft\Excel\XLSTART
In Vista look here
C:\Users\Ron\AppData\Roaming\Microsoft\Excel\XLSTART

Note: Ron is the username in the path above
With code you find the correct path on your machine with this line

1) Open excel
2) Hit alt-F11 to get to the VBE
3) Hit ctrl-g to see the immediate window and type this:
4) ?Application.StartupPath

You’ll see the startup path returned

Bit maybe it is blocked ?

When Excel think the file is corrupt it can disable the file.
You can re-enable it here but if it is really corrupted replace it with a backup.

Excel 2002-2003: Help>About MS Excel>Disabled items
Excel 2007 : Office button>Excel Options..Add-ins
In the "Manage:" dropdown (bottom of the dialog)
Choose "Disabled Items
Go



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

this worked great but now not loading at startup as before for some reason.
using xl 2007 on XP.
wonder if an update changed something?
personal.xlsb resides at
c:\d&s \username\application data\microsoft\excel\xlstart
tried to go to excel options, advanced and enter the path above for open at
startup
you can point to this file and it will open, but prefer to open at startup
thx

__________ Information from ESET Smart Security, version of virus signature database 3945 (20090318) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 3945 (20090318) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[reno]

it was disabled and works again....thx

C:\Documents and Settings\Ron\Application Data\Microsoft\Excel\XLSTART
In Vista look here
C:\Users\Ron\AppData\Roaming\Microsoft\Excel\XLSTART

Note: Ron is the username in the path above
With code you find the correct path on your machine with this line

1) Open excel
2) Hit alt-F11 to get to the VBE
3) Hit ctrl-g to see the immediate window and type this:
4) ?Application.StartupPath

You’ll see the startup path returned

Bit maybe it is blocked ?

When Excel think the file is corrupt it can disable the file.
You can re-enable it here but if it is really corrupted replace it with a backup.

Excel 2002-2003: Help>About MS Excel>Disabled items
Excel 2007 : Office button>Excel Options..Add-ins
In the "Manage:" dropdown (bottom of the dialog)
Choose "Disabled Items
Go



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm







__________ Information from ESET Smart Security, version of virus signature database 3945 (20090318) __________

The message was checked by ESET Smart Security.

http://www.eset.com