If this information is useful, please mark as helpful. I mean, does my code leaves any loopholes. Or if you had time to advise, would you recommend different code. Would you recommend the above mentioned code for this task. Please post back if you have any more problems or questions. I created a dummy Access database to import in excel, this is for learning purpose. However, you must have this workbook open when you use this data source or when you refresh a query that is pulling data from this data source. If you have the password protected workbook open in Microsoft Excel, you will be able to successfully create a data source for this workbook. You can create your data source without receiving an error message. Click Yes when you are prompted to replace the existing file with the same name. Locate and select the workbook with the password.ĥ.Ğnter the password for the workbook and click OK.ħ.Ĝlick the drop-down arrow next to Tools, and click General Options.Ĩ.ĝelete the text in the Password to open box and click OK.ĩ.Ĝlick Save. To work around this problem, remove the password from the workbook.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2023
Categories |