report export pdf with visual basic macro example

[murathoca]

hello I want to export a report created in hopex with a macro. Is there an example simple code?

With to visual basic macro for PPM Module Report To Export File Pdf Example macro

[murathoca]

How can I add the marked place in the picture to the macro above.

[murathoca]

I am not giving the latest updated report. I need to click on the actions button. how can I add this to the macro you sent me.

[murathoca]

thank you very much

[bzambeaux]

Yes, the report is regenerated and contains fresh data

[murathoca]

screenshot is attached below

[murathoca]

Firstly, thank you. code worked 🙂 how to add new refresh field in this marked area to this code. Or does this code automatically take the current report?

[oguimard]

Here is an example of script 

Dim oRoot,oAnalysisPlugin,oAnalysis,sFile

  Dim oSource : Set oSource = getObjectFromId("MyReportID")

                Set oRoot = GetRoot

                Set oAnalysisPlugin = oRoot.CurrentEnvironment.GetMacro("~9MuFp4qmBD40[Analysis Plugin]")

                Set oAnalysis = oAnalysisPlugin.newAnalysisFromMegaInstance(oSource,false)

  oAnalysis.setDestinationFile "C:\Temp\MyFileName.pdf"

                sFile = oAnalysis.Generate("PDF",MySelf,Nothing)

print "OK"