Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel application.quit in macro problem | New Users to Excel | |||
How to stop Excel remembering/loading macro from previously opened Workbook | Excel Discussion (Misc queries) | |||
Macro Help In Excel | Excel Discussion (Misc queries) | |||
Closing File Error | Excel Discussion (Misc queries) | |||
passing arguments from an excel macro to a word macro | Excel Discussion (Misc queries) |