I have developed a complex set of math formulas in excel.
I have also developed a very nice looking publisher output design that pulls (at links) the results and charts from the excel workbook.

Is there a way that I can create a macro in excel that will open a specific Publisher file, say yes to updating, then export as a PDF that publisher program?

At this point just a simple yes or no would work great or even an example someplace for me to play with it if it can be done.

Thanks very much,

Ken