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-OPSNSW 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
It looks like you've already got the basic code - just amend for example FileToOpen in your first routine to use a specific path and file name rather than a prompt.