Re: Export multiple objects to excel (multi sheets) without opening the excel application
Gysbert - can I ask for a simpler response? (Keep it Simple Stupid...for me). I have this code and would like to expand it to multiple tables say (TB01, CH01, LB01, etc, etc), on multiple tabs - one object to a tab, and preferably in xlsx format (instead of xls).
Has anyone seen this explained in video format? Youtube maybe? I'm very new to this scripting and I need something to walk me through the logic that CLEARLY explains what each step does. I'm not able to follow the example very well...though I will keep trying. Thank you in advance for any assistance.
DIM ExcelApplication, ExcelWorkbook
SET ExcelApplication = CREATEOBJECT("Excel.Application")
SET ExcelWorkbook = ExcelApplication.Workbooks.Add