January 30, 2020
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
November 1, 2018