Personal.xls Issues in Excel 2007
Hello,
I am somewhat new when it comes to macros. I have recorded a few but I am in new territory right now. After trial and error I finally figured out how to get my existing personal.xls that is on my work computer running Excel 2003 onto a new computer running Excel 2007.(XP for both OS). I copied my existing personal.xls into C:/Program Files/Microsoft/ Office12/XLStart (if it matters) and it seems to be working fine. However, during my trial and error, I ended up adding a Personal.xlsb file. Currently this file has nothing in it. What is the difference between .xls and .xlsb? If I do not need it, I would like to delete it- and I am not sure how. Another thing that is different is now when I open Excel, the blank workbook (book1) does not appear. It is just a blank blue screen with the Excel toolbar on top. I have to do a couple of steps to create and open a blank workbook. Also, when try to close down Excel, I hit the very top right "X" and only the workbook disappears. I am back at the blank blue screen with the Excel toolbar on top. I was hoping to get this back to standard version, ie when I open Excel, a new workbook shows up and when I close it down, Excel itself will close. As I said before, I am somewhat new with macros and any advice and suggestions would be greatly appreciated. Thank you for your time in advance. |
Personal.xls Issues in Excel 2007
Hi cardan
See http://www.rondebruin.nl/personal.htm Copy your old personal xls in C:\Documents and Settings\<username\Application Data\Microsoft\Excel\XLSTART Remove the one in Office12/XLStart between .xls and .xlsb? xlsb is one of the new formats (with code) and can be a bit smaller. Another way is to copy your code in this add-in and have a nice menu http://www.rondebruin.nl/qat.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "cardan" wrote in message ... Hello, I am somewhat new when it comes to macros. I have recorded a few but I am in new territory right now. After trial and error I finally figured out how to get my existing personal.xls that is on my work computer running Excel 2003 onto a new computer running Excel 2007.(XP for both OS). I copied my existing personal.xls into C:/Program Files/Microsoft/ Office12/XLStart (if it matters) and it seems to be working fine. However, during my trial and error, I ended up adding a Personal.xlsb file. Currently this file has nothing in it. What is the difference between .xls and .xlsb? If I do not need it, I would like to delete it- and I am not sure how. Another thing that is different is now when I open Excel, the blank workbook (book1) does not appear. It is just a blank blue screen with the Excel toolbar on top. I have to do a couple of steps to create and open a blank workbook. Also, when try to close down Excel, I hit the very top right "X" and only the workbook disappears. I am back at the blank blue screen with the Excel toolbar on top. I was hoping to get this back to standard version, ie when I open Excel, a new workbook shows up and when I close it down, Excel itself will close. As I said before, I am somewhat new with macros and any advice and suggestions would be greatly appreciated. Thank you for your time in advance. |
All times are GMT +1. The time now is 02:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com