I have a spreadsheet with the tab names as the date of the monthly data. How do I set the month for each table in the script when I load the files? So May 2010, June 2010, July 2010 tabs are loaded individually and in the load statement, when I input "Set date" or "set month" or Set May" I get an error statement. I hope that makes sense.
and The QV Cookbbok example, "Load multiple sheets from Excel workbook". The first part of the example, "Mutli Sheet load" is just like your example except you don't need to filter out sheets. The SheetName variable in the script can be parsed to get the month and year for your MakeDate.