MS Excel 4.3 macro migration

J

JDT

I am trying to migrate a MS excel workbook created in Office 4.3 to MS Excel
2000. I have copied folders and files to new machine but have runtime errors
when trying to run the spreadsheet functions in Excel 2000. I have done some
searching about file migration but am still unsure of what I need to do to
have these macros run without errors. Any help would be greatly appreciated!
JDT
 
N

Nick Hodge

JDT

May be easier to know what they are doing as XL, even to the latest version
(2007) supports V4 stuff

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk
 
J

JDT via OfficeKB.com

Nick said:
JDT

May be easier to know what they are doing as XL, even to the latest version
(2007) supports V4 stuff
I am trying to migrate a MS excel workbook created in Office 4.3 to MS
Excel
[quoted text clipped - 6 lines]
appreciated!
JDT

Nick thank you for responding,

Here is the error that I am encountering: Run time error "1004" Application
defined or object defined error. When I click to debug the VB editor points
me to the line Sub open Toolbars ("Soil_Specifier")
..visible = false.

Thank you,

JDT
 
N

Nick Hodge

If this is loading a toolbar (never worked in V4) then you will need to
convert this to the Office CommandBar object to load it as they were changed
in XL97

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk


JDT via OfficeKB.com said:
Nick said:
JDT

May be easier to know what they are doing as XL, even to the latest
version
(2007) supports V4 stuff
I am trying to migrate a MS excel workbook created in Office 4.3 to MS
Excel
[quoted text clipped - 6 lines]
appreciated!
JDT

Nick thank you for responding,

Here is the error that I am encountering: Run time error "1004"
Application
defined or object defined error. When I click to debug the VB editor
points
me to the line Sub open Toolbars ("Soil_Specifier")
visible = false.

Thank you,

JDT
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top