Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
JDT JDT is offline
external usenet poster
 
Posts: 1
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,173
Default 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


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,173
Default 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


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
Excel application.quit in macro problem TimkenSteve New Users to Excel 3 August 17th 06 06:36 PM
How to stop Excel remembering/loading macro from previously opened Workbook Norman Yuan Excel Discussion (Misc queries) 4 June 17th 06 04:13 PM
Macro Help In Excel welshlad Excel Discussion (Misc queries) 14 October 26th 05 02:34 PM
Closing File Error jcliquidtension Excel Discussion (Misc queries) 4 October 20th 05 12:22 PM
passing arguments from an excel macro to a word macro KWE39 Excel Discussion (Misc queries) 1 July 7th 05 03:56 PM


All times are GMT +1. The time now is 02:37 AM.

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

About Us

"It's about Microsoft Excel"