Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm using Access 2000 to create charts in Excel. I've read about the
problem Excel not quitting due to a global reference to the automated application at http://www.tushar-mehta.com/excel/vba/xl_doesnt_quit/ So I've tried to reference objects explicitly. For example: With xlapp.Workbooks(strXlsFile).Worksheets(sn(i)) .[do stuff] End With But Excel still does not quit. Sometimes I need to assign the return value of a method to an object - when creating a chart or adding a series, for example: Dim objChart as Object Set objChart = xlapp.Workbooks(strXlsFile). _ Worksheets(sn(i)).ChartObjects.Add(Left:=100, Top:=24, _ Width:=650, Height:=500).Chart With ObjChart .[do stuff] End with Dim objSeries as Object Set objSeries = objChart.SeriesCollection.NewSeries With objSeries .[do stuff] End With Is this why Excel is not quitting? Do either of the above two examples constitute a global reference? Can this code be written so it does not create a global reference? Could there be some other reason why Excel is not quitting? Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Global replace a reference to a worksheet | Excel Discussion (Misc queries) | |||
Need to avoid a circular reference... | Excel Worksheet Functions | |||
How to Reference Global Variable for external application. | Excel Programming | |||
Quitting Excel without saving | Excel Programming | |||
Global file reference change | Excel Programming |