topic Moving excel sheets using qlikview macro in QlikView

Moving excel sheets using qlikview macro

eliran — Tue, 08 May 2012 12:37:29 GMT

Hey all,

I'm having issues moving sheet location in excel using Qlikview macro.

The standard command is:

Sheets("Sheet1").Move After:=Sheets(3)

Sadly, the macro fails.

Any help?

Regards,

Eliran.

m_woolf — Tue, 08 May 2012 12:53:48 GMT

Mr. Google says:

Set oExcel = CreateObject("Excel.Application")

Set oWorkBook = oExcel.Workbooks.Add

oWorkbook.Sheets("Sheet1").Move ,oWorkbook.Sheets( oWorkbook.Sheets.Count )

eliran — Wed, 09 May 2012 07:53:42 GMT

I'm probably loosing it.

I have searched for it but didn't find the answer.

Thanks!

Eliran.