Forum

Importing specific ...
 
Notifications
Clear all

Importing specific excel file from a folder

2 Posts
2 Users
0 Reactions
89 Views
(@stevenbehr1)
Posts: 92
Estimable Member
Topic starter
 

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

 
Posted : 21/09/2021 5:54 am
(@debaser)
Posts: 838
Member Moderator
 

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.

 
Posted : 21/09/2021 6:58 am
Share: