Excel connects to Demantra and load data from Demantra worksheet.

Hi

I understood that Demantra could not export its graph to Ms Excel.

Currently, Demantra user exports data from Demantra to Excel manually. Next, she creates a graph from the data on Excel.

I would like to get rid of the manual steps.

Can I develop a macro in Excel? When she clicks on a button named "Generate Report" on a Excel Tab, the macro should connect Excel to Demantra and open a specific worksheet and then load the data from Demantra worksheet to the Excel spreadsheet.

Next, the macro creates a graph based on the data exported.

Thank you.