topic Re: Error with a macro in QlikView

Error with a macro

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello, Merry Christmas and happy holidays!
I'm having an issue with a macro that exports some tables from QlikView to an Excel document.
I'm trying to do some coloring in all of its sheets, as per customer's requirements, but I keep getting "Expected end of statement" at this For loop, and I don't know why:

For i = 1 To 6

XLDoc.Sheets(i).Select

XLDoc.Sheets(i).Range("A1:C2,K1:Q2,Q3:Q37,Y1:AE2,AE1:AE19").Interior.Color = RGB(255,255,0)

next i

Any ideas? I'm new to VBA so I'll appreciate all the help I can get

Re: Error with a macro

tamilarasu — Thu, 28 Dec 2017 08:19:22 GMT

Below link might be helpful.

Macro to export multiple tables in to single excel

Re: Error with a macro

petter — Thu, 28 Dec 2017 09:34:14 GMT

QlikView does not use the VBA (Visual Basic for Applications). It supports the VBS (Visual Basic Script) which is the little brother of VBA. Not as capable.

VBS syntax does not support the variable name after the NEXT statement. It supports only the Next. So simply by removing the i after Next your syntax error will be gone.

Re: Error with a macro

Anonymous — Thu, 28 Dec 2017 09:49:55 GMT

This explains a lot...
Thanks for the info.

Re: Error with a macro

YUVARAJ — Tue, 28 Feb 2023 09:08:10 GMT

Hi Peter,

QlikView license is automatically converted to personal edition during run time of automatic scheduled jobs.

And the jobs are carrying the macro programming .the above error is comming.Please help with the solution.

but we are getting this error around 500+ report a day we are getting this during every batch file run.

Regards,

Yuvaraj G

Yuvarajqlik1994@gmail.com