Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Kill Excel application process
I porgramming under Visual Basic 6 and Visual Studio .NET 2003, using Win XP.
I have a next problem. After i close my soft., then i cannot run excel corretly - the center part of the excel is not visible. A create a code like this: 1. Create a reference 2. Inicialize excel app from visual basic: Dim ExcelApp As New Excel.Application Dim ExcelWB As Excel.Workbook = ExcelApp.Workbooks.Add Dim ESheet As Excel.Worksheet = ExcelWB.Worksheets(1) 3. Do with ESheet what i need 4. Try to kill excel application: ExcelWB.Close() ExcelApp.Quit() ESheet = Nothing ExcelWB = Nothing ExcelApp = Nothing But if i after this run excel with directly clicking on excel sheet on desktop, the excel don't run correctly. Thank you for your help, and sorry my english. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Kill Excel application process
HoGo,
If this is VB6, you will not be able to compile in the first place as: Dim ExcelWB As Excel.Workbook = ExcelApp.Workbooks.Add is not valid. You need: Dim ExcelWB As Excel.Workbook Set ExcelWB = ExcelApp.Workbooks.Add If this is not VB6, I can't help you much. NickHk "HoGo" wrote in message ... I porgramming under Visual Basic 6 and Visual Studio .NET 2003, using Win XP. I have a next problem. After i close my soft., then i cannot run excel corretly - the center part of the excel is not visible. A create a code like this: 1. Create a reference 2. Inicialize excel app from visual basic: Dim ExcelApp As New Excel.Application Dim ExcelWB As Excel.Workbook = ExcelApp.Workbooks.Add Dim ESheet As Excel.Worksheet = ExcelWB.Worksheets(1) 3. Do with ESheet what i need 4. Try to kill excel application: ExcelWB.Close() ExcelApp.Quit() ESheet = Nothing ExcelWB = Nothing ExcelApp = Nothing But if i after this run excel with directly clicking on excel sheet on desktop, the excel don't run correctly. Thank you for your help, and sorry my english. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Kill Excel application process
Hi
Put ExcelApp.Visible = True early on for testing purposes. Because Excel may ask you things, like "save changes ?" and if you don't see or reply then she won't close properly. Which would be a problem at least he ExcelWB.Close() ExcelApp.Quit() Please clarify "excel don't run correctly" HTH. Best wishes Harald "HoGo" skrev i melding ... I porgramming under Visual Basic 6 and Visual Studio .NET 2003, using Win XP. I have a next problem. After i close my soft., then i cannot run excel corretly - the center part of the excel is not visible. A create a code like this: 1. Create a reference 2. Inicialize excel app from visual basic: Dim ExcelApp As New Excel.Application Dim ExcelWB As Excel.Workbook = ExcelApp.Workbooks.Add Dim ESheet As Excel.Worksheet = ExcelWB.Worksheets(1) 3. Do with ESheet what i need 4. Try to kill excel application: ExcelWB.Close() ExcelApp.Quit() ESheet = Nothing ExcelWB = Nothing ExcelApp = Nothing But if i after this run excel with directly clicking on excel sheet on desktop, the excel don't run correctly. Thank you for your help, and sorry my english. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail merge issue - ghost Excel process remains after closing application | Excel Programming | |||
Mail merge issue - ghost Excel process remains after closing application | 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 |