Moving excel sheets using qlikview macro

[eliran]

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 · Accepted solution]

Mr. Google says:

Set oExcel = CreateObject("Excel.Application")

Set oWorkBook = oExcel.Workbooks.Add

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

[eliran]

I'm probably loosing it.

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

Thanks!

Eliran.