topic Re: Export multiple objects to excel (multi sheets) without opening the excel application in QlikView

Export multiple objects to excel (multi sheets) without opening the excel application

Anonymous — Thu, 22 Oct 2015 06:49:13 GMT

Hi, i have a question,

i've followed this thread Export Qlikview objects to multiple Excel sheet and it works perfectly.

But, when i ran the macro it open the excel application. My question is, is it possible to directly save/create the excel file without opening the Ms Excel Appllication ?

Really appreciate your help.

Thanks

Re: Export multiple objects to excel (multi sheets) without opening the excel application

Gysbert_Wassenaar — Thu, 22 Oct 2015 08:15:32 GMT

No, you will need to create an excel instance. But nobody's stopping you from cleaning it up at the end of the macro with something like SET MyExcelApp = Nothing;

Re: Export multiple objects to excel (multi sheets) without opening the excel application

Anonymous — Thu, 22 Oct 2015 08:20:40 GMT

Hi,

Ow I see, i got it.

Okay thanks for the explanation

Re: Export multiple objects to excel (multi sheets) without opening the excel application

crichter14 — Thu, 01 Mar 2018 22:35:42 GMT

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.

Code Example:

Sub ExcelFile

DIM ExcelApplication, ExcelWorkbook

SET ExcelApplication = CREATEOBJECT("Excel.Application")

SET ExcelWorkbook = ExcelApplication.Workbooks.Add

ActiveDocument.GetSheetObject("TB01").CopyTableToClipBoard TRUE

ExcelWorkbook.Worksheets(1).Paste

ExcelApplication.DisplayAlerts = FALSE

ExcelWorkbook.SaveAs "C:\Users\admin.cherylr\Documents\test.xls", 56

ExcelApplication.Quit

MsgBox "Export Complete"

End Sub

Re: Export multiple objects to excel (multi sheets) without opening the excel application

tamilarasu — Fri, 02 Mar 2018 05:58:48 GMT

Hi Cheryl,

Start a new discussion. You might get a quick response. Good luck.

Re: Export multiple objects to excel (multi sheets) without opening the excel application

tamilarasu — Fri, 02 Mar 2018 06:07:24 GMT

Hi Cheryl,

Start a new discussion. You might get a quick response. I have attached a sample file for your reference. Hope this is what you are looking for. Good luck.