Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Mr. Google says:
Set oExcel = CreateObject("Excel.Application")
Set oWorkBook = oExcel.Workbooks.Add
oWorkbook.Sheets("Sheet1").Move ,oWorkbook.Sheets( oWorkbook.Sheets.Count )
Mr. Google says:
Set oExcel = CreateObject("Excel.Application")
Set oWorkBook = oExcel.Workbooks.Add
oWorkbook.Sheets("Sheet1").Move ,oWorkbook.Sheets( oWorkbook.Sheets.Count )
I'm probably loosing it.
I have searched for it but didn't find the answer.
Thanks!
Eliran.