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.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.