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
|