Importing specific excel file from a folder|VBA & Macros|Excel Forum|My Online Training Hub

Evening All,

Im creating Custom UI database and I have a program where a person can upload a excel data from specified folder and imported to a sheet. This is good so that people can pick and choose what data they want.

What I now need is a code where a person can press an icon and knowning that there is a folder H:\PROJECT-OPS\NSW Warehouse and excel file is NSWTAInventoryListing.xlsx I would like to do the same with the code listing that data goes into sheet2 from the XLSX file from that folder.

I have the project attached with the VBA to test. There is 2

Sub Get_Data_From_File &

Sub Get_Data_From_File 1

Thanks

Steve Behr