I still have the problem that the connection object becomes empty once the file open code is finished running so the connection string is not accessible later on. You did give me the idea to create a worksheet that will store the connection string but is hidden from the user and is deleted when the file is closed.
Thanks