I have created an Excel file through Cognos Reportnet SDK. This Excel file has a reference to another htmlfile which has the data. So when I open the Excel File, I get this message:
Some of the files in this web page aren't in the expected
location. DO you want to download them anyway? If you're sure the
web page is from a trusted source, click Yes.
When I click on Yes, the Excel opens up with the data. I have Excel 2000. In my vb.net code I would like to save the Excel file as new.xls, which will now contain the data, without having to look at the external html file. My code is as below. I am unable to achieve this. ANy help would be appreciated. Thanks
Dim filename as string="c:\temp\test.xls"
Dim as system.object
Dim objExcelWOrkbook as New Excel.Application