VBA error - file not found

Question

I run Access, Excel and Windows in MS Offce 365 on 2 PCs in Windows 10.

I was doing some development in VBA Access on the desktop. I closed and opened the DB and went to open the VBA code. I got a message "File not found". I have been looking around to see what the problem is.

It occurs on all ACcess .accdbs. Also on docxm and xlsm. I am able to run the applications correctly. I am able to export the basic modules to a text file. They run correctly on the other PC, a laptop. And there I can view & edit the code.

Any help in solving this issue would be greatly appreciated.

Answer 1

Open Start > Settings > Apps > Apps & features

Scroll down to Microsoft Office

Select it

Click Change

Now, wait while the repair wizard starts up.

Choose the type of repair you would like to perform. Depending on the severity or availability of your Internet connection, you could try the first option, Quick Repair, which is much faster and tries to fix the problem without a data connection.

If that doesnâ€:tm:t resolve the problem, then go back and try the Online Repair option. For my particular issue, I ultimately had to use the Online Repair.

The repair process is straight-forward following the wizard. Note that youâ€:tm:ll need to save your work and close all Office programs first, and then click Repair.

Then wait while the repair process runs.

You will notice the repair experience is similar to a fresh installation. The amount of time it takes will depend on your connection speed and what the issue is.

You will see your Office apps light up in their respective colors while the repair completes.

Once the installation is complete, restart your computer just to be sure and launch your apps and verify if the problem you were having is resolved.

Answer 2

Hello

Thank you for your fast response. Before I tried it out I got another response (repair MicroSoft Office) which I decided to try first and it solved the problem. Therefore I cannot say if your solution would have solved my problem or not - and I'm not sure how to answer the question "Did this solve your problem?" so I've left it for now.

Thank you again for taking the time to suggest a solution

Best regards

John Tompa

Answer 3

Hello

Thank you for your answer and solution. The quick repair did not solve the problem, but the online one did. In Access, Exel and Word I can now edit my visual basic code.

And thank you also for your fast response

Best regards

John Tompa

Answer 4

Hi there, thanks for your question.

The first step I would try is starting Access in Safe Mode:

https://support.office.com/en-us/article/open-o...

If that doesn't help, try repairing it:

https://support.office.com/en-us/article/repair...

You could also try these general troubleshooting steps:

Perform a clean boot:

https://support.microsoft.com/en-au/help/929135...

Boot into Safe Mode to see if the problem persists:

https://support.microsoft.com/en-au/help/12376/...

Run the System File Checker tool:

https://support.microsoft.com/en-us/help/929833...

DISM:

https://support.microsoft.com/en-au/help/947821...

If the issue persists after trying these steps, please let me know! Thanks!