Hello all,
I have created a spreadsheet that takes information exported from another program and prints out different worksheets based on the information from the export. I use this spreadsheet multiple times a day and am looking to make a short key to bypass the steps required in actually importing the data. The exports all go to lets say "Z:\invmac". The exported file has a unique number as its file name. I want the macro to get the data from this folder and wait for the user to input the unique file name and then continue on with the import. Is this possible?
I have created a spreadsheet that takes information exported from another program and prints out different worksheets based on the information from the export. I use this spreadsheet multiple times a day and am looking to make a short key to bypass the steps required in actually importing the data. The exports all go to lets say "Z:\invmac". The exported file has a unique number as its file name. I want the macro to get the data from this folder and wait for the user to input the unique file name and then continue on with the import. Is this possible?
