Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Automation VS.NET2003
after objExcel.Quit I would have
objWorkbook = Nothing objWorkbooks = Nothing objExcel = Nothing or the .Net equivalent. -- Regards, Tom Ogilvy "Jeff Grundy" wrote in message ... When I create a Windows Forms Application using VB.NET2003 and have that application create and save a workbook, I cannot open the worksheet with Excel until I close the VB application. Steps to reproduce the problem. 1 Create a Windows Forms Application. 2 Add a reference to 'Microsoft Excel 9.0 Object Library'. 3 Add a command button to Form1 (Button1). 4 Add the following code to the form: '***Begin Code*** Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim objExcel As Excel.Application Dim objWorkbook As Excel.Workbook Dim objWorkbooks As Excel.Workbooks objExcel = New Excel.Application objWorkbooks = objExcel.Workbooks objWorkbook = objWorkbooks.Add objWorkbook.SaveAs("C:\TempWorkbook.xls") objExcel.Quit() End Sub '***End Code*** 5 Run the program. 6 Click the button 1 time. 7 In windows explorer double click the file C:\TempWorkbook.xls. At this point Excel opens but the grid area does not display correctly. 8 Close excel. 9 Close the VB application by clicking the x button in the corner of form1. If you click 'Stop Debugging' in the IDE an Excel process will continue to run in Task Manager- Processes Tab. You need to 'End Process' or rebbot to get rid of it. 10 In windows explorer double click the file C:\TempWorkbook.xls. At this point Excel opens the file correctly. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Excel with automation | Excel Discussion (Misc queries) | |||
Excel spradsheet automation help | New Users to Excel | |||
Vb.net - excel 97 automation | Excel Programming | |||
XLL - VS .Net2003 - init problem - const char strings - /Gf option?? | Excel Programming | |||
XLL - VS .Net2003 - init problem - const char strings - /Gf option?? | Excel Programming |