I need to do some exports to excel filtering by some different clients and then send them by e-mail following a schedule.
I tried to call the macro from the vbs but I couldn't find the proper way, I looked for in the forum and I got some shell scripts but not vbs, so a workaround is calling the push event from a button that executes the macro.
Is there any other way to call the macro from vbs? it looks strange because lots of things can be done from vbs.
Another problem is the vbs doesn't wait until the macro finishes, so it continue executing other things, I found a workaround using a variable as a traffic light and I do a qvDoc.GetApplication.WaitForIdle 2000 inside a while.
My question is, is there any other more elegant way?
WaitForIdle is the right way to wait for all calculations to be finished after the previous command.
I'm not sure what you mean by "calling the macro from vbs"? If you mean "ways of calling a VBScript macro", then you can invoke them from buttons, other objects that can trigger actions, or from document-level and sheet-level triggers.
cheers,
Oleg Troyansky
www.masterssummit.com - take your QlikView skills to the next level!
