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:
'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
msgbox("Datei "&filepath3&" erstellt")
The test shows no errors and it worked fine in version 11.
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.
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?