Importing External Data - Selecting Table question
I have an excel file that imports data from three sources. I have used
the import external data option and recorded a macro to automate the process. However the worksheets names within the three sources possibly will be changing from import to import. Is there a way for a dialog box to appear for the user to choose the name of the worksheet to import or have the worksheet names appear in a list to have the user choose from. Any help would be greatly appreciated. Ed |
All times are GMT +1. The time now is 07:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com