Thread: PERSONAL.XLSB
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default PERSONAL.XLSB

You can find it here

If it exists, you can find the file in the Excel startup folder.
C:\Documents and Settings\Ron\Application Data\Microsoft\Excel\XLSTART
In Vista look here
C:\Users\Ron\AppData\Roaming\Microsoft\Excel\XLSTA RT

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

Youll see the startup path returned


--

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


"LVS" wrote in message ...
How can I delete PERSONAL.XLSB in Excel 2007?