from access to excel

[sharon_R]

Hi everybody,

I've got a macro in excel that imports some data from a name.mdb file. For several weeks it worked with no problems, but since a couple of days, when I run it, it shows me a message of it does not find the file name.mdb (showing the whole path), suggesting me that use the file name.mdb (the same one previous with the same previous path). If I agree, a series of windows appears in order to confirm the file, the password and all that, and then coppy all the the requested information. This message appears before execute:

.Refresh BackgroundQuery:=False


Any suggestion???

Thanks in advance

Sharon

[jetted]

Hi

Strange problem it is probably a variable that is not define properly. To elimate this theory put at the begin of your code Option Explicit. This will let you know that every variable has been declare properly.

[sharon_R]

Thank you Denis, but this seems to be something different. I moved both files to another folder (changing the path in the code) and now is working well again , but still I not sure if that is the solution.

Sharon