topic Re: VBA And Macro in QlikView

VBA And Macro

johnan — Sat, 19 Oct 2019 10:13:07 GMT

Hi all, i have a simple VBA file to reload an application.

In this QV i have a macro that export some images. The problem is it won't run the macro right, it's just open the macro window.

So my question is there is possible to run this macro in the VBS fil?

Export images into a location in the computer?

Br

Re: VBA And Macro

m_woolf — Mon, 21 Oct 2019 12:42:01 GMT

It's really hard to answer this question without seeing the macro code.

Re: VBA And Macro

johnan — Mon, 21 Oct 2019 13:20:39 GMT

Here you go!

function exportImages
' Test if export should be made
set v = ActiveDocument.Variables("RunNow")
if v.GetContent.String = "Yes" then
v.SetContent "No",true
exportAll
ActiveDocument.GetApplication.Quit
end if
end function

function exportAll
export("CH97")
export ("TX09")
end function

function export(chartId)
set obj = ActiveDocument.GetSheetObject(chartId)
obj.ExportBitmapToFile "C:\inetpub\wwwroot\as400\UTL\Chart_" & chartId & ".png"
end function

Re: VBA And Macro

jaibau1993 — Mon, 21 Oct 2019 13:47:17 GMT

Hi! if the macro window is opened when you run it it is because there is an error in your code. You can use the "test" button to locate the error and get some info:

On the other hand, yes, what you need can be done. I checked your code and it runs perfectly in my computer. Check objects IDs, check that those objects are visible, check the path where you save the pics and verify that you allow system acces

Regards,

Jaime.

Re: VBA And Macro

johnan — Mon, 21 Oct 2019 14:14:20 GMT

I have testit, and get memory problems and strange errors.. Sometime it works, sometime not.

Can i run a batfile? Like this.

"C:\Program Files\QlikView\Qv.exe" /I /r "C:\Qv\ManifestOrdersBILD.qvw"

If i run above, the qlikview will not reload it 😞

Re: VBA And Macro

Brett_Bleess — Thu, 24 Oct 2019 12:53:27 GMT

Johnan, I believe the /r and /l are mutually exclusive, one or the other in regard to those, I will try to confirm, but I suspect that is why things are not working for you, if you do one or the other there, I suspect that should get things working.

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Starting_QlikView.htm

I am going to submit a doc defect regarding the fact this is not clear in the Help, but I did confer with a coworker and he thought the same thing, so I am pretty sure we are correct here, you have to use the /r or /l...

Regards,
Brett