MS Excel 4.3 macro migration

  • Thread starter Thread starter JDT
  • Start date Start date
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
 
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
 
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
 
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

Back
Top