Share via

Access VBA code not working after update to Office 365

Anonymous
2020-05-18T17:41:08+00:00

I have A LOT of VBA code I wrote a few years ago. I run the same code every Monday to automate some tasks around exporting a spreadsheet from the database. This Monday (first Monday after the update to Office 365), I ran the same code and received a Method or data member not found (Error 461). I have seen this before in the past with other Office updates. I fixed it by installing a different code library that references old syntax. Does anyone know how to do this for the Office 365 update?

Microsoft 365 and Office | Access | 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

Answer accepted by question author

  1. ScottGem 68,810 Reputation points Volunteer Moderator
    2020-05-18T23:11:48+00:00

    Based on the code you are Dimming bkMultMfr as an Excel object. So I suspect the tweak that the SaveAs method is no longer valid and you used a different method of the object.

    In any case I'm glad you found it. Can you mark this as resolved.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments

6 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-05-18T21:46:59+00:00

    I figured it out with a little tweek of the code.

    Thanks...

    Was this answer helpful?

    0 comments
  2. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  3. Anonymous
    2020-05-18T19:31:29+00:00

    Thanks for the quick response, Scott. Here is the part of the code I get an error with (highlighted). The error I get is: 

    Method or data member not found (Error 461)

    Was this answer helpful?

    0 comments
  4. ScottGem 68,810 Reputation points Volunteer Moderator
    2020-05-18T19:09:55+00:00

    Hi Mic, I'm an independent adviser and will try to help.

    Each version of Access tightens up VBA syntax. So older code that may have run well for years, may break. Instead of installing older reference libraries it might be better to fix the code.

    It would help if you showed us the code that is broken, especially the line that throws the error.

    If you check the References do ay show as Missing? If so, which one(s)? Do you know what code library you think you need to replace?

    Please provide more info so we can help.

    Was this answer helpful?

    0 comments