Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
XLStart is empty but Personal is still running - sort of
XL2003 on XP on an old AMD xp2400 chip
I have taken my Personal.xls out of XLStart but it keeps running? Evidently it is still there but windows cannot see it The Personal.xls is currently 14mb Each day I update my Personal program on a Compaq laptop with Vista and transfer across using a USB drive. The vista machine (2.0gig duocore) is incredibly unreliable and I do not know from one day to the next whether the code will run. It is normal for vista to encounter a problem and wipe out the vba code in the process. I have been having the problem of the Personal.xls running when it is not in the XLStart on the Vista laptop for sometime. But now it is showing up on my XP desktop. The result is that I am currently out of business as the program is the center of my investment business. Can I simply remove the XLStart folder and create a new one. Or is there some way of cleaning the folder. Everything I try seems to make the problem worse. Any help would be greatly appreciated. Ta, Martin Wheeler |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
XLStart is empty but Personal is still running - sort of
"Martin Wheeler" wrote: XL2003 on XP on an old AMD xp2400 chip I have taken my Personal.xls out of XLStart but it keeps running? Evidently it is still there but windows cannot see it The Personal.xls is currently 14mb Each day I update my Personal program on a Compaq laptop with Vista and transfer across using a USB drive. The vista machine (2.0gig duocore) is incredibly unreliable and I do not know from one day to the next whether the code will run. It is normal for vista to encounter a problem and wipe out the vba code in the process. I have been having the problem of the Personal.xls running when it is not in the XLStart on the Vista laptop for sometime. But now it is showing up on my XP desktop. The result is that I am currently out of business as the program is the center of my investment business. Can I simply remove the XLStart folder and create a new one. Or is there some way of cleaning the folder. Everything I try seems to make the problem worse. Any help would be greatly appreciated. Ta, Martin Wheeler I have just removed the XLStart folder and had Office CD repair excel. But I moved the Personal file to My Documents whilst the repair was being done. Now the toolbar cannot find the macros in the XLStart folder,Personal file How do I redirect the buttons? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
XLStart is empty but Personal is still running - sort of
Maybe you have that personal.xls in the folder that excel uses when it opens.
Tools|Options|General tab Make sure that the "at startup, open all files in:" textbox is empty. If that's not it, open excel. Unhide personal.xls if you have to (window|Unhide) Then type: =cell("Filename",a1) in any cell You'll see the location of this personal.xls. ===== Depending on your upgrade path, you could have multiple XLStart folders. Martin Wheeler wrote: XL2003 on XP on an old AMD xp2400 chip I have taken my Personal.xls out of XLStart but it keeps running? Evidently it is still there but windows cannot see it The Personal.xls is currently 14mb Each day I update my Personal program on a Compaq laptop with Vista and transfer across using a USB drive. The vista machine (2.0gig duocore) is incredibly unreliable and I do not know from one day to the next whether the code will run. It is normal for vista to encounter a problem and wipe out the vba code in the process. I have been having the problem of the Personal.xls running when it is not in the XLStart on the Vista laptop for sometime. But now it is showing up on my XP desktop. The result is that I am currently out of business as the program is the center of my investment business. Can I simply remove the XLStart folder and create a new one. Or is there some way of cleaning the folder. Everything I try seems to make the problem worse. Any help would be greatly appreciated. Ta, Martin Wheeler -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
XLStart is empty but Personal is still running - sort of
The toolbar has icons that point at macros in workbooks. If you move the
workbook, you'll have to reassign the macros to the new location. Open the file with the macros. Tools|Customize (Just to see the dialog) rightclick on each of the icons|Assign macro and point to the new personal.xls. ===== I think your life will be lots easier if you create that toolbar when the workbook opens and destroy it when the workbook closes. Some references if you want to look at that option: For additions to the worksheet menu bar, I really like the way John Walkenbach does it in his menumaker workbook: http://j-walk.com/ss/excel/tips/tip53.htm Here's how I do it when I want a toolbar: http://www.contextures.com/xlToolbar02.html (from Debra Dalgleish's site) And if you use xl2007: If you want to learn about modifying the ribbon, you can start at Ron de Bruin's site: http://www.rondebruin.nl/ribbon.htm http://www.rondebruin.nl/qat.htm -- For macros for all workbooks (saved as an addin) or http://www.rondebruin.nl/2007addin.htm In xl2007, those toolbars and menu modifications will show up under the addins. Martin Wheeler wrote: <<snipped I have just removed the XLStart folder and had Office CD repair excel. But I moved the Personal file to My Documents whilst the repair was being done. Now the toolbar cannot find the macros in the XLStart folder,Personal file How do I redirect the buttons? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
#1) value vs. formula #2) personal.xls and xlstart pathway | Excel Programming | |||
Shortcut to personal.xls in XLStart forlder | Excel Programming | |||
Multiple users running macro from personal.xls | Excel Programming |