Hi Guys,
New to VBA so steep learning curve.
I read a number of threads particularly the Pull data from closed workbooks in same folder, as I have a similar challenge.This was between ( ceytl and johnnyL ) did some great work
So I have a 150 or so xlsx files in a dropbox folder called Invoices 2019-2021 and a file called Invoice register 1.xlsm for the macro and results.
Within the folder Invoices 2019-2021 I have a file typically starting at Inv 291.xlsx
I am am looking to get data from each xlsx file and list it down sequentially starting from A2 in my invoice register 1 file.
I would not want to open each of the xlsx files just to get the data.
thanks in advance
New to VBA so steep learning curve.
I read a number of threads particularly the Pull data from closed workbooks in same folder, as I have a similar challenge.This was between ( ceytl and johnnyL ) did some great work
So I have a 150 or so xlsx files in a dropbox folder called Invoices 2019-2021 and a file called Invoice register 1.xlsm for the macro and results.
Within the folder Invoices 2019-2021 I have a file typically starting at Inv 291.xlsx
I am am looking to get data from each xlsx file and list it down sequentially starting from A2 in my invoice register 1 file.
I would not want to open each of the xlsx files just to get the data.
thanks in advance