topic Re: Macro stopps without error - only in version 12.20 - in QlikView

Macro stopps without error - only in version 12.20 -

f1234567 — Sat, 16 Nov 2024 17:43:19 GMT

Hi experts,

I found a strange behavior, starting with QV version 12.20. (In QV 11 it has been working all right):

After loading some data I want to export one file to excel.

I use this macro:

Sub Excel_Export
'Export als Excel Datei
strFP3 = ActiveDocument.Variables("vExportPathCloud").GetContent.String

Set objExcel = ActiveDocument.GetSheetObject("CH57")
strName = ActiveDocument.Variables("vNameExcelExp").GetContent.String
filepath3 = strFP3 &strName 'edit the location of file
objExcel.ExportBiff filepath3
msgbox("Datei "&filepath3&" erstellt")
End Sub

The test shows no errors and it worked fine in version 11.

Strange:

Starting the macro: macro runs, then QV opens the macro, so that above text can be read. But it does not export the xls file.

So, first I thought the reason are the variables (vNameExcelExp,vExportPathCloud) . But the variables are generated and I can show them up in text-boxes.

My work-around:

I safe and close QV and then reopen QV. After that starting the macro works all right. The xls-file is exported.

I also tested:

Just saving QV and starting the macro: macro stopps

Has anybody of you seen a similar behavior?

What could be the reason?

Many thanks!
Frank

Re: Macro stopps without error - only in version 12.20 -

marcus_sommer — Thu, 10 Dec 2020 14:22:45 GMT

Just put a msgbox below each statement and you will find the point where the macro breaks. If you here returned the variable-values you could also check if they are correct within the macro, too. Also an On Error Resume Next and a msgbox err.number & err.description may give further hints to the cause. Other often needed statements in regard to exports are WaitForIdle- and Sleep-statements to ensure that Qlik finished all calculations before going to the next statement and to give the OS enough time to perform the addressed I/O.

Further your issue might be caused through a mixmatch of different releases - creating, updating and usage release and also between client and server releases. Another look might go to the use of prj-folders.

Beside this why upgrading now to 12.2 which is already out of support - and if I remember correctly the first releases of 12.2 has had some bugs. The most current version is 12.5 SR3.

- Marcus

Re: Macro stopps without error - only in version 12.20 -

f1234567 — Sat, 12 Dec 2020 10:14:24 GMT

Hi Marcus,

thanks a lot!
Of course, you are right concerning the versions. However, I had no choice and had to install 12.20 😩

I now added some Sleep-statements after each variable setting and it now works. I am testing now how many seconds of pausing at what step is necessary.

Thanks a lot!

Frank