To anyone that can help me.
I am trying to import an Excel file from a computer in my local network. I am new to VBA so to do this I recorded a macro. The macro works as long as I have logged on to the computer that the folder is in that holds the file I am trying to import. If I start my computer and run the Macro before I go on the network and look into the folder I am trying to get to I receive a OLE DB Jet Driver Initialization MessageBox. If I then search the network for this computer and then try again it works fine.
Can anyone tell me how to do this a different way or how to Initialize the Jet driver within my code.