I am using visual basic to open multiple spreadsheets and copy rows of data into one spreadsheet.
I have done this by using workbooks.open and then specifying the filename,
however, I would like to open all spreadsheets in the folder without having
to add the names of each as these will be changing
Can anyone help?