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 05:32:47
Alex Lam
Hong Kong
 
 
To
18/05/2011 03:24:42
Viv Phillips
Hay-On-Wye, United Kingdom
General information
Forum:
ASP.NET
Category:
Coding, syntax and commands
Title:
Re: Generate excel file but close it,cache Excel in task man
Environment versions
Environment:
VB 9.0
OS:
Windows XP
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01510527
Message ID:
01510957
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))
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform