Does Cameo Report Wizard block VBA scripts?
Posted: Sun May 14, 2023 6:57 amI have a small VBA script in my Report Wizard template file that splits the document into 2-page pdf files.
When I run the Report Wizard this vba script is also in the generated file.
But even though it's set to run on "close" I have to wait until the report wizard finishes generating it, then open the generated file, then close it before the script will run.
I'd like the vba to run automatically after the report is generated without having to open it then close it.
Doesn't Cameo have to "close" the word doc after it's finished populating it?
If so, then shouldn't the vba script be run then?
Or does Cameo block vba scripts from executing somehow while it has control over the document?
When I run the Report Wizard this vba script is also in the generated file.
But even though it's set to run on "close" I have to wait until the report wizard finishes generating it, then open the generated file, then close it before the script will run.
I'd like the vba to run automatically after the report is generated without having to open it then close it.
Doesn't Cameo have to "close" the word doc after it's finished populating it?
If so, then shouldn't the vba script be run then?
Or does Cameo block vba scripts from executing somehow while it has control over the document?