Running Navision reports from excel

[KarlHenrik65]

I have an excel application that is relying on data from a Navision report being run every month on a specific time. Today this is done manually, but I would like to do this programatically ie trigger a macro to run this report. Is it at all possible to run Navision reports and retrieve data from them this way, can the shell functionality be applied or any other solution, any suggestions is appreciated
thanks
Henrik

 

[Special-K99]

Info on NaVision and exporting to Excel here

Tutorial: Import Data from Navision into Excel. By David Carter | AccountingWEB