Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 112
Default 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.

  #2   Report Post  
Posted to microsoft.public.excel.programming
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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel 2007 saving issues CXH Excel Discussion (Misc queries) 0 June 4th 10 06:52 PM
Personal.xls and Excel 2007 Mike H Setting up and Configuration of Excel 0 October 4th 09 11:05 AM
Analysis Toolpack Issues in Excel 2007 (Office 2007 Enterprise) Ben Shields Excel Discussion (Misc queries) 2 February 24th 09 05:04 PM
Display issues in Excel 2007 Vinnypie Excel Discussion (Misc queries) 0 September 11th 08 07:00 PM
Personal.xls in Excel 2007 Peter K Setting up and Configuration of Excel 4 December 14th 07 08:56 PM


All times are GMT +1. The time now is 10:42 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"