Greetings;
I need to have a user import a file that he or she would select, and have it import to a specific sheet that will probably be hidden in the final Excel workbook. I recorded a macro that imports a file onto the sheet I currently have active with cell A1 selected.
Of course, if I run that macro it imports the same file into whichever sheet I have selected although it WILL start the data in cell A! no matter which cell I have selected.
How do I modify the macro to allow the user to select a specific file to import and force the data to be imported to a specific sheet?
Thanks.
John
Bookmarks