Below is the code I have tried. I get an xls file with the right name in a dialog box to open, save or cancel. However, when I try to open it, I get the message that the Excel 97-2003 file is corrupted.
Appreciate if you could help me with appropriate modifications to the below code.
Thanks,
Swamy
Code:
Protected Overrides Sub GenerateReport() Dim