VBA, Checking the open-status of a office-document

Checking the open-status of a office-document

Author	Message
Christian Hel #1 / 3	Checking the open-status of a office-document How can I check from access-vba if an excel-file is opened? My problem is that I'm getting just errors when I'm trying to open an already opened file. 1) Is it possible to multiple open a document? 2) If not, how can I be sure, that it is not open 3) when the document is open, how can it be closed from vba? Thanks for your help, Christian Hell -- _____________________________________________________________ NewsGroups Suchen, lesen, schreiben mit http://www.--*.com/
Wed, 27 Nov 2002 03:00:00 GMT

Cindy Meister -WordMVP #2 / 3	Checking the open-status of a office-document Hi Christian, Quote: > How can I check from access-vba if an excel-file is opened? My problem is that > I'm getting just errors when I'm trying to open an already opened file. How are you trying to open it? Show us your code? Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister http://go.compuserve.com/MSOfficeForum This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-)
Sat, 30 Nov 2002 03:00:00 GMT

Wout de Groo #3 / 3	Checking the open-status of a office-document Hi, Christian, Maybe the following code will help you. For intI = 1 To xlApplication.Workbooks.Count If xlApplication.Workbooks(intI).Name = strFileName Then Set xlBook = xlApplication.Workbooks(intI) xlBook.Close SaveChanges:=True Exit For End If Next intI Wout de Groot. Quote: > How can I check from access-vba if an excel-file is opened? My problem is that > I'm getting just errors when I'm trying to open an already opened file. > 1) Is it possible to multiple open a document? > 2) If not, how can I be sure, that it is not open > 3) when the document is open, how can it be closed from vba? > Thanks for your help, > Christian Hell > -- > _____________________________________________________________ > NewsGroups Suchen, lesen, schreiben mit http://netnews.web.de
Sat, 30 Nov 2002 03:00:00 GMT

Page 1 of 1

[ 3 post ]