Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Generate excel file but close it,cache Excel in task man
Message
 
To
15/05/2011 22:16:26
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:
01510753
Views:
45
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform