I have a macro-based Excel file (Excel 2010).
I'm evaluating the components, and wondering is I can do the following...
On a server (running .NET 3.5) I want to...
1. Open it (test.xlsm)
2. Modify one value
3. Update the values (run the macros)
4. Save it (test2.xlsm)
5. Create a PDF ((test2.pdf)
Can I do this?
A. I can create a sample.xml (as in the HelloWorld tutorial)
Good (Simple)
B. I can create a PDF from sample.xls (as using the tutorial)
Good
C. If I try to do this is a marco excel workbook (ie sample.xlsm), I get "Value cannot be null."
I guess this is because you cannot open Macro-Enable Excel Workbooks?
Bad - Help?
D. I cannot open the sample.xml and save it (sample2.xml) -
I get "Name of worksheet must be unique in a workbook."
I guess because I am using the evaluation version? How can I test this?
Bad - Help?
Any ideas suggestions or comments would be appreciated.
Thank you.