A VBA Macro to export data from Mega

[ngurjar]

Hello,

Does any one have an example of VBA Macro for exporting data out of Mega.
I want to export following datafields out of Mega in an excel
Application--> Abs ID of the Applications--> Application Owner (Person Assignment)--> Login and Email of the Application Owner (Person(System))
I would really be grateful if you can provide me a sample code whereby i can build my code further on it Or is there any other possibility to build such a report in Mega? I have tried Report Dataset and that doesnt help.

Note I am using Hopex V1R3CP13.

Greetings
Nik

[JPTourne]

Hello @ngurjar 
You mention that you want the data out of Hopex.

The Report Dataset is a good hint to build the data.

How would you manage the automated refresh and extraction of the dataset?

Merci,

Jean-Philippe

[ngurjar · Accepted solution]

Hello,

I figured a workaround via Report Dataset.



Greets
Nik