Share via

Excel 2000 VBA Macro Runtime Error - Any update that fixes it?

Anonymous
2017-04-08T22:04:58+00:00

I am using Office 2000 SP3 on Windows XP SP3. I understand that official support for these products may have ended.

The government agency in my country have released a template that is Excel 97-2003 template with VBA macros in it.

At one point during running the macro it gives run time error.

Talking to the agency was futile as they simply asked me to reinstall Office and Windows as their proposed solution!!

Is there any MS Update for Office 2000 that would actually fix this issue? What else shall I try?

I managed to get access to the VBA code. The precise statement where it crashes is

Dim asc As Object

Set asc = CreateObject("System.Text.UTF8Encoding")

Thanks

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-04-09T01:22:20+00:00

    Sorry, but without the VBA project password, there's not much you can do to pinpoint the error. Is there anyway you can get a hold of the template owner/developer?

    0 comments
  2. Anonymous
    2017-04-09T21:41:14+00:00

    Thanks SmittyPro1 Yes finally I managed to access the code and have updated the question accordingly.

    2 people found this answer helpful.
    0 comments
  3. Anonymous
    2017-04-09T22:22:31+00:00

    It's hard to tell what's going on with out the full context of what the code is intended to do. This thread might help shed some light: http://p2p.wrox.com/vbscript/29099-unicode-utf-8-system-text-utf8encoding-vba.html

    0 comments