Problem with read only error message and XLSTART folder

[andrewsn]

I have a file called Personal.XLSB that stores all of the macros I have written. This file is stored in Program Files/Microsoft Office/Office12/XLSTART and it loads every time Excel starts.

So I've got some macros that are scheduled to run automatically. When they run, they'll open a new instance of Excel. However, because Excel is already open, I get an error because it tried to load my Personal.XLSB file and tells me "The file is already open, would you like to open as read-only?"

My macros always get stuck because that error message gets in the way. Is there a way to get this error message out of the way or work around it?

 

[andrewsn]

Never mind guys. I ended up running the line below to solve my problem.

Workbooks("Personal.xlsb").ChangeFileAccess Mode:=xlReadOnly

To switch the file back to normal I then used:

Workbooks("Personal.xlsb").ChangeFileAccess Mode:=xlReadWrite

 

[andrewsn]

Actually never mind the never mind.

Does anyone know how I can change the files that Excel loads upon start up?

 

[mooseman]

Actually never mind the never mind.

Does anyone know how I can change the files that Excel loads upon start up?

Change the files that are in your XLStart folder.
SO(metimes the folder gets corrupted and you need to close Excel, move the files in it, delete the folder, restart Excel (this creats the folder again), then move your files back into it.