Hi people,

I use the following code to import data from an access table in to excel. However database is password protected. I have added the password in to the code below on numerous lines but whenever I run the macro the password box pops up. When I enter the password the macro runs fine but what am I missing? This should work without the password box popping up but I really can not see why it does not automatically enter.

I have posted this on another forum but with no luck. Any help is appreciated.

Please Login or Register  to view this content.