Access Macro Invalid Path

Question

Hello All,

I have received a database from a colleague who has departed our organization.  The database operates using a macro that pulls an excel file.  The macro is set up to look up the file on his computer which is an invalid path now.  How can I edit the file path of the macro to change it to pull the excel file from my computer?

Answer 1

The OP here specified a "macro". In Access macros are different from VBA and you cannot edit a macro through the VBA editor. Both your answers were incorrect.

Answer 2

You can open with VBA, it will show you the code, finally you can edit your Path

Answer 3

You need to know which macro is causing the Error. The Error message you get should show the name of the macro. In the Navigation Pane (on the left), scroll down to the Macro section and select the macro in question. Right click and Open in Design mode. One of the lines in the macro should specify the location of the Excel file. Just change it to the correct location.

Note: I"m guessing you are the only one who uses this app. If not, then you might want to change the file location to somewhere on your network.

Answer 4

Do you know which macro has the old path?

If not, go to the VBA editor and press Ctrl+F and search for it or part of it. Then replace what is there with the new path.

Answer 5

If you are using Office applications, excel, you can select workbook -> Open contatiner folder. Or you can activate VBA, at plus F11, opn container