Link to home
Start Free TrialLog in
Avatar of Lozza64
Lozza64

asked on

How to get new file in VBA Code

I need to alter the 'GetNewFile' code in VBA in the attached spreadsheet so that when the Target Import File button is clicked a new file is imported each time. At the moment it shows the location of the new target file in the button but when 'Import Data' is clicked it still imports the previous file. I have attached the spreadsheet containing the macro and also the two excel files containing the information that I want to import into the spreadsheet.

Thanks in advance.
WLK-Raw-Template.xlsm
Book1.xls
Book1345.xls
ASKER CERTIFIED SOLUTION
Avatar of dlmille
dlmille
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Jacques Geday
Jacques Geday
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial