Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 16th 05, 10:03 PM
Kath
 
Posts: n/a
Default Excel 97 macros to Excel 2003

Old Excel files were transferred to another computer to be opened with Excel
2003. In the old system, there were a number of relatively simple macros that
were used on these files and were attached to a custom macro toolbar.
How do I make sure that these macros and the toolbar are also transferred
and functional in Excel 2003 without having to redo them. A number of them
are in the personal.xls file in the old system.
Thanks,
Kath

  #2   Report Post  
Old February 17th 05, 07:44 AM
Nick Hodge
 
Posts: n/a
Default

Kath

You should be able to replace the personal.xls you currently have into the
installation of XL2003. It will need to be copied away, just in case and
then moved into the XLStart folder of the new installation.

Toolbars attached to this or any workbook should be OK. If you have
customised toolbars in XL, these too can be saved by locating a file called
Excel.xlb. (It may have a slightly different name but will have an *.xlb
extension), move it away before installation and then replace the one that
XL installs

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Kath" wrote in message
...
Old Excel files were transferred to another computer to be opened with
Excel
2003. In the old system, there were a number of relatively simple macros
that
were used on these files and were attached to a custom macro toolbar.
How do I make sure that these macros and the toolbar are also transferred
and functional in Excel 2003 without having to redo them. A number of them
are in the personal.xls file in the old system.
Thanks,
Kath





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
How do you install help for excel 4.0 macros in Office 2003? Macliam Excel Discussion (Misc queries) 9 February 4th 05 03:08 AM
Excel 2003 Macros Not Accessible Darrell Excel Discussion (Misc queries) 3 January 18th 05 06:23 PM
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 1 January 5th 05 08:36 AM
can a workbook with macros created in excel 2003 work in excel 20. Steve Venti Excel Discussion (Misc queries) 2 December 27th 04 02:31 PM
how can i edit excel 4 macros in Excel 2003 Pedrito1967 Excel Worksheet Functions 0 December 7th 04 07:21 PM


All times are GMT +1. The time now is 05:39 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017