Excel/Access Macros work on Windows 98 but not Windows 2000

ktwc · Apr 24th, 2002, 01:34 AM

I've recently updated to Windows 2000 and have found a problem that stops Microsoft Excel from working. The macros were written on a Windows 98 platform for Office 97 using Office 8.0, Access 8.0 and Excel 8.0 Obkect Libraries, OLE, & Visual Basic for Applications Libraries. The macro starts in Excel, links to Access for some SQL work then back to Excel.

Now that I've upgraded to Windows 2000 I ran the macro, it worked twice then Excel wouldn't start. Even from a reboot it still displayed the same error message and would not start.

Could Office be affected to this degree just by running a macro?

Tom Schreiner · Apr 24th, 2002, 01:38 AM

Hi
What is your error and post your code as well.
Excel does not start at all?
Or just the macro?
Thanks,
Tom

ktwc · May 13th, 2002, 07:41 AM

I've solved my problem. The Windows API is different for Windows 98 and Windows 2000. The macros were originally developed on Windows 98 and so the compiled code uses Windows 98 API. When the same macros are tried on Windows 2000, the API is different and so the code doesn't run correctly and causes unforseen problems.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 24th, 2002, 01:34 AM	#1
ktwc New Member Join Date: Apr 2002 Location: Scotland Posts: 3	I've recently updated to Windows 2000 and have found a problem that stops Microsoft Excel from working. The macros were written on a Windows 98 platform for Office 97 using Office 8.0, Access 8.0 and Excel 8.0 Obkect Libraries, OLE, & Visual Basic for Applications Libraries. The macro starts in Excel, links to Access for some SQL work then back to Excel. Now that I've upgraded to Windows 2000 I ran the macro, it worked twice then Excel wouldn't start. Even from a reboot it still displayed the same error message and would not start. Could Office be affected to this degree just by running a macro?

Apr 24th, 2002, 01:38 AM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Hi What is your error and post your code as well. Excel does not start at all? Or just the macro? Thanks, Tom

May 13th, 2002, 07:41 AM	#3
ktwc New Member Join Date: Apr 2002 Location: Scotland Posts: 3	I've solved my problem. The Windows API is different for Windows 98 and Windows 2000. The macros were originally developed on Windows 98 and so the compiled code uses Windows 98 API. When the same macros are tried on Windows 2000, the API is different and so the code doesn't run correctly and causes unforseen problems.