Macro to call a program

[johnan]

Hi,
I have a button to call a program in QV. Can I load button so that after the script is loaded to automatically make a button press? Or a macro for this?

[manishkumar75]

Hi Johnan,

As per my understanding (I may be wrong) , you want a macro to be run on the opening of QlikView document. If it is so, you can assign that macro to Document Event Triggers - > On Open , using Document properties and selecting Macros tab.

- Manish

[johnan]

Yes, thats correct. But, when you create a button, you can call a program. I have a "batfile" that i want to execute after reloading the document.

If i can call that batfile in macro and then execute after reloading the script, i't would be nice.

Sorry for my bad english

[#4]

Hello Johnan,

You can perhaps use a macro like this:

Sub LaunchBatch
 set app=ActiveDocument.GetApplication
 app.Launch "c:\test.bat",""
End Sub

regards Mark

[johnan]

Hi, i tried but:

Expected end of statement

in macro

[#6]

Try this:

doc = ActiveDocument
b = doc.GetSheetObject("BU99")
b.Press

Regards,

Gordon

[#7]

johnan wrote:
Hi, i tried but:

Expected end of statement
in macro

It works over here, what version of QlikView do you use? Did you point to an existing bat file?

[johnan]

8.50

[johnan]

Hi,

got this error:

Object required: 'doc'

[#10]

Copy/paste lost 'set'.

Set doc = ActiveDocument
Set b = doc.GetSheetObject("BU99")
b.Press