VBA Code doesnt not run. No error message displayed.

[imsuneaik]

Hi everyone, I have a VBA code that allows me to ultilise File Dialog to import Excel file into Access Database. The strange thing is the same vba code works for one DB file but not the other. Both the 2 DB files are identical in some ways.

However, when running the code on the other DB, no error message can be displayed.

 

[theDBguy]

Hi. Are you able to step through the code execution in the failing db? Is it stored in a trusted location?

 

[imsuneaik]

Hi. Are you able to step through the code execution in the failing db? Is it stored in a trusted location?

Yes both files are stored under a trusted location/directory. I tried stepping through the code execution but still no display of errors messages or popups. Thanks

 

[theDBguy]

Yes both files are stored under a trusted location/directory. I tried stepping through the code execution but still no display of errors messages or popups. Thanks

Well, I asked about stepping through the code because your topic title says that the VBA code is not running. So, if you're able to step through the code during execution, then it's running, correct?

 

[arnelgp]

maybe re-check the reference again of Microsoft Office XX.X Object Library.