Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Generate excel file but close it,cache Excel in task man
Message
De
18/05/2011 09:28:14
 
 
À
18/05/2011 05:32:47
Information générale
Forum:
ASP.NET
Catégorie:
Code, syntaxe and commandes
Versions des environnements
Environment:
VB 9.0
OS:
Windows XP
Database:
MS SQL Server
Application:
Desktop
Divers
Thread ID:
01510527
Message ID:
01510983
Vues:
42
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform