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
12/05/2011 22:19:23
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:
01510591
Views:
42
>Hi all,
> i write a export excel function ... Can generate a excel file in screen, if close it , the user can select save or not save.......
>But anyway user save and quit the excel or direct quit excel...... i find the task manager still exits excel.exe,
>how can i do, thx?
>
>
>  Public Sub genexcel()
>        
>        Dim XL As Excel.Application
>        Dim WB As Excel.Workbook
>        Dim Sheet As Excel.Worksheet
>
>        XL = CreateObject("Excel.Application")
>        XL.Visible = True
>
>        WB = XL.Workbooks.Add
>
>        Sheet = WB.ActiveSheet
>        Sheet.Activate()
>
>
>
>       XL.Visible = True
>
>        XL.UserControl = True
>
>        Sheet = Nothing
>
>        WB = Nothing
>
>        XL = Nothing
>
How do you introduce "Excel" ?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform