Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Generate excel file but close it,cache Excel in task man
Message
 
À
15/05/2011 22:16:26
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:
01510753
Vues:
46
>Sorry, i don't know what mean introduce "Excel" ?
>
>I only this code, i reference Com, (Microsoft Excel 9.0 Object Library)
>
>I can generate the excel file , but if i quit the excel or save as excel file after exit. In this time, i call the task Manager , still see excel.exe is running?
>How can i do ..... thank you

Instead of Microsoft Excel 9.0 Object Library, and instead of calling CreateObject, try:
       'reference to Microsoft.Office.Interop.Excel added to project
        Dim XL As New Microsoft.Office.Interop.Excel.Application
        Dim WB As Microsoft.Office.Interop.Excel.Workbook
        Dim Sheet As Microsoft.Office.Interop.Excel.Worksheet
        ' XL = CreateObject("Excel.Application")
Good Luck
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform