I designed Web App using VB.NET and I want to add a new feature.
User would click on a link button on a web page and that would basically start following process behind the scene:
1. 2 numeric values are retrieved from Database and stored in 2 hidden labels in web page (know how to do this)
2. My .NET code then should open a specific XSL spreadsheet (path to this file is known)
3. Those 2 numeric values known to .NET will be then insterted into specific 2 places (cells) in the XSL spreadsheet
4. Excel file would then run a predesigned and saved macro
5. Ideally then Excel file would Publish itself into PDF file and would save itself to a known place on HD (path and file naming convention would be known and specified)
So basically - how to write VB.NET code to open an Excel file, run macros in it, and save it as a PDF?
Thanks
Start Free Trial
