wrecks
05-02-2009, 07:26 AM
I am processing a Word document which contains some Microsoft Graph charts. I will read and possibly change the data in a graph DataSheet.
I can find the graphs and open a DataSheet (inspect InlineShapes, OLEFormat, Edit, Object, Application, DataSheet) and get at the cells. But I'm having trouble cleaning up when done!
I just want to "Close" the DataSheet window, but there is no Close method (only Activate). The only thing I have found is OLEFormat.Object.Application.Quit -- that works, but oddly it takes 5 or 10 seconds to execute. Weird.
Using Word manually, all I have to do is type Ctrl+F4 or click the little X in the upper right corner of the Datasheet window. But damn if I can figure out how to do this from VBA.
Am I missing something obvious?
Thanks in advance...
I can find the graphs and open a DataSheet (inspect InlineShapes, OLEFormat, Edit, Object, Application, DataSheet) and get at the cells. But I'm having trouble cleaning up when done!
I just want to "Close" the DataSheet window, but there is no Close method (only Activate). The only thing I have found is OLEFormat.Object.Application.Quit -- that works, but oddly it takes 5 or 10 seconds to execute. Weird.
Using Word manually, all I have to do is type Ctrl+F4 or click the little X in the upper right corner of the Datasheet window. But damn if I can figure out how to do this from VBA.
Am I missing something obvious?
Thanks in advance...