Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Generate excel file but close it,cache Excel in task man
Message
From
18/05/2011 09:28:14
 
 
To
18/05/2011 05:32:47
General information
Forum:
ASP.NET
Category:
Coding, syntax and commands
Environment versions
Environment:
VB 9.0
OS:
Windows XP
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01510527
Message ID:
01510983
Views:
41
>You mean i need .net interop DLLs. But i open it , i saw two Microsoft.Office.Interop.Excel version 11 or 12.
>After i add the Microsoft.Office.Interop.Excel version 12. and run program .
>
>In this code, Sheet.Range("C" & iRow).Value = "AAA" will error.
>
>COMException was unhandled
>HRESULT: 0x80020011 (DISP_E_NOTACOLLECTION))

I think Range() requires two parameters. See: http://msdn.microsoft.com/en-us/library/microsoft.office.tools.excel.worksheet.range(v=vs.80).aspx
Previous
Reply
Map
View

Click here to load this message in the networking platform