Hi, thanks for the code. I have tried to use it, but after I have chosen the folder, it displays
Run-time error '2455':
You entered an expression that has an invalid reference to the property FileSearch.
Pressing on Debug it takes me to this line: With Application.FileSearch
Hi Isskint,
Is it possible for you to make me a code which I can just copy and paste into VBA? I have no prior knowledge of VBA, and what I know, are the extreme basic :S
I need this to be done if possible. I want to be able to make a form, where it says the folder, then click Upload. It will look inside that folder, and import all the files inside into separate tables. The names of the tables will be based on as followed.
The name of the excel will be in this...