MS Excel 4.3 macro migration
 

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

MS Excel 4.3 macro migration
 

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
DTHIS
www.nickhodge.co.uk


"JDT" <u29417@uwe wrote in message news:69a2162696d60@uwe...
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

MS Excel 4.3 macro migration
 

Nick Hodge wrote:
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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200611/1

MS Excel 4.3 macro migration
 

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
DTHIS
www.nickhodge.co.uk


"JDT via OfficeKB.com" <u29417@uwe wrote in message
news:69ae582eacae2@uwe...
Nick Hodge wrote:
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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200611/1