Issue: Generating Reports Automatically Using Prepared Template File

[Ahmed AlSahaf]

Hi,

I've created an add-on based on ExcelDNA. The add-on provides the user custom functions that get values from a web service I have. These custom functions are Async. They get updated values dynamically every time the source changes using  ReExcel and ExcelAsyncUtil. Now I've created a small program that runs in the background, opens a prepared excel file every day, refreshes the values from the web service then generate a report as pdf .The issue I'm facing is, I'm not able to get/update the values and generate the pdf using the program I created. All the dynamic values in the pdf file appear as #NAME? even when I call CalculateFullRebuild() on the Excel application object or RefreshAll() on the WorkBook object. 

All these functions are Async, I need to open the file, call refresh, wait for it to finish, then export as pdf.

Thanks,

Ahmed