ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   PERSONAL.XLSB (https://www.excelbanter.com/excel-programming/418864-personal-xlsb.html)

LVS

PERSONAL.XLSB
 
How can I delete PERSONAL.XLSB in Excel 2007?

Ron de Bruin

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?




All times are GMT +1. The time now is 09:16 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com