View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Moving Excel 2003 templates from XP to Windows 7

These personally designed macro buttons were placed on a Toolbar or just on
the worksheet?

If on a Toolbar, you either attach that Toolbar to the workbook or create
the Toobar "on the fly" when the personal.xls is opened.

Otherwise you will need to copy your old Excel11.xlb to the new OS

I don't use Windows 7 but I am sure it stores your personal.xls in same
place as before.

Record a macro and see where personal.xls winds up.

When you know that, replace the newly-built one with your old personal.xls.


Gord

On Fri, 15 Jan 2010 16:00:52 -0800 (PST), PT wrote:

On Jan 15, 9:59*am, Gord Dibben <gorddibbATshawDOTca wrote:

What file type is your current workbook? *.xls, *.xlt or *.xla

Personal.xls

How do the Toolbars and macro buttons get loaded..........code or
otherwise?

The Personal.xls was set up as a blank open single sheet
workbook, containing seven personally written macros, each invoked by
a personally designed macro button.

Where was the workbook stored before you moved to Windows 7?

Personal.XLS is located in c:\Program Files\Microsoft Office |
Office 11 \ XLStart

Hope this Helps.