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

[ktwc]

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?

 

[Legacy 98055]

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

 

[ktwc]

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.