Macro that needs user input to import excel files
I am trying to build a macro that allows a user to input the excel file name
in certain filepath. The macro then should import that file into this workbook in the same format. I am thinking of having some kind of drop down menu box that will help user pick the file that he/she wants to import and then as soon as he clicks the file name the macro imports that file in the same format by inserting a new worksheet. Is this possible? Please help. |
All times are GMT +1. The time now is 09:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com