Is it possible to import the worksheets from all files in a folder to a single file as separate worksheets using VBA on Excel 2011 for Mac?
I am exporting reports from Filemaker Pro, however it can only export the found sets as separate Excel files. I would like to then transfer each excel file into a single master excel file as a separate worksheet. VBA is a bit complicated to figure out from scratch so any help would be greatly appreciated.
Thank you very much,
Shaun
I am exporting reports from Filemaker Pro, however it can only export the found sets as separate Excel files. I would like to then transfer each excel file into a single master excel file as a separate worksheet. VBA is a bit complicated to figure out from scratch so any help would be greatly appreciated.
Thank you very much,
Shaun