cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

A VBA Macro to export data from Mega

ngurjar
Retired

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

2 Replies

JPTourne
MEGA
MEGA

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
Retired

Hello,

I figured a workaround via Report Dataset.

Reportdataset.png

Greets
Nik