Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am running Excel from MS Access. Basically I populate some cells from
Access data and then save and activate the workbook. After closing excel an Excel.exe process remains in task manager. How do I get this to end and still show the workbook? Code is: Dim appExcel As Object Dim WBook As Object 'OPEN EXCEL Set appExcel = CreateObject("Excel.Application") Set WBook = appExcel.Workbooks.Open(strTemplateDir & strWBName) Excel.Application.DisplayAlerts = False With appExcel .Range("A11").Value = Nz(Trim(rst![CustomerName]), " ") .Range("A12").Value = Nz(Trim(rst![Address]), " ") .Range("A13").Value = Nz(Trim(rst![City]), " ") & ", " & _ Nz(Trim(rst![State]), " ") & " " & Nz(Trim(rst![Zip]), " ") .ActiveWorkbook.SaveAs filename:=strDocDir & strFileName, _ FileFormat:=xlNormal, Password:="", WriteResPassword:="", _ ReadOnlyRecommended:=False, CreateBackup:=False .Visible = True End With ErrorHandlerExit: rst.Close Set rst = Nothing Set WBook = Nothing Set appExcel = Nothing Exit Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel shoud not close all active books when clicking close button | Excel Discussion (Misc queries) | |||
excel - Windows close button (x) should only close active workboo. | Setting up and Configuration of Excel | |||
How to count process running time ( process not finished) | Excel Programming | |||
How to count process running time ( process not finished) | Excel Programming | |||
Open/Close Event and Excel Saving process | Excel Programming |