Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
help!kill process excel.exe
i have created a excel workbook in vb,below are the codes: private sub report () Dim sfilename As String Dim spath As String Dim dtecurrent As Date Dim msexcel As Object dtecurrent = Now Set msexcel = CreateObject("Excel.Application") With msexcel ..Visible = False ..Workbooks.Open "d:\DYNAMICS\PDB\RPT.xls", , False End With With msexcel.Application ..ActiveWorkbook.ActiveSheet.Select ..Cells(2, 1) = Time ..Cells(2, 2) = Date End With sfilename = Format(dtecurrent, "mmddyyyy HHMMSS") & ".xls" spath = System.BasePath & "\htrdata\" & sfilename msexcel.ActiveWorkbook.SaveAs spath 'Saves the file with the path msexcel.Visible = True Set msexcel = Nothing end sub ********* in the program i call the function period,because the excel run in background,so the problem is every time it will add a windows process, how can i close the process in the function? -- xz739 ------------------------------------------------------------------------ xz739's Profile: http://www.excelforum.com/member.php...o&userid=37053 View this thread: http://www.excelforum.com/showthread...hreadid=567780 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Kill Excel Process | Excel Programming | |||
How to Kill Excel application process | Excel Programming | |||
Quit Method do not kill excel process | Excel Programming | |||
Quit Method do not kill excel process | Excel Programming | |||
to kill a excel process | Excel Programming |