Excel 2011 Mac - Import Worksheets into a Single File

S

sirsancho

Joined
Feb 2, 2012
Messages
1
Reaction score
0
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How import a MS Excel Userform into Mac Excel? 3
Split an Excel file into separate files 3
Utility to flatten/import X12 834 file into Excel 3
Excel Formula to add network file link to each month 1
Export multiple Excel sheets to a single text file 3
Excel VBA help: Text file formatting 19
VBA - Importing Sheets 18
Mac Excel 2001 and PageSetup.PaperSize = xlPaperLetter 1

Top