Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

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

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    Scotland
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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?

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

  3. #3
    New Member
    Join Date
    Apr 2002
    Location
    Scotland
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •