 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2008How does Excel determine if a file is already in use?
Is it only if the OS tells it? I've posted a message (with no response) so I'm asking a different way. In VBA terms, it would be part of the Workbooks collection. If you were so inclined, here is a UDF (User Defined Function) that would tell you if a specific book is open. Function IsOpen(wbook As String) As Boolean Dim wb as Excel.Workbook IsOpen = False On Error Resume Next Set wb = Workbooks(wbook) If Err = 0 then IsOpen = True End If On Error Goto 0 Exit Function HTH, JP On Mar 19, 1:26 pm, "Paul MacFarlane" <pmacfarl...@mullenlaw.com> wrote: > Is it only if the OS tells it? > > I've posted a message (with no response) so I'm asking a different way. Thanks JP... What I am finding is there are some other things going on with this workbook too... If I copy the workbook to a local drive I get this XLQUERY.XLA missing message: http://support.microsoft.com/kb/277620 Although the workaround doesn't... But having it work from the local drive indicates a network (OpLocks) problem. In VBA terms, it would be part of the Workbooks collection. If you were so inclined, here is a UDF (User Defined Function) that would tell you if a specific book is open. Function IsOpen(wbook As String) As Boolean Dim wb as Excel.Workbook IsOpen = False On Error Resume Next Set wb = Workbooks(wbook) If Err = 0 then IsOpen = True End If On Error Goto 0 Exit Function HTH, JP On Mar 19, 1:26 pm, "Paul MacFarlane" <pmacfarl...@mullenlaw.com> wrote: > Is it only if the OS tells it? > > I've posted a message (with no response) so I'm asking a different way. What version of XL are you using? If you aren't using XL 97, you shouldn't be saving in that format (unless you need backward compatibility for some reason). --JP On Mar 19, 1:57 pm, "Paul MacFarlane" <pmacfarl...@mullenlaw.com> wrote: > Thanks JP... > [quoted text clipped - 6 lines] > But having it work from the local drive indicates a network (OpLocks) > problem. XL2003... Not saving in that format. The person that created the file doesn't have XLQUERY.XLA on his machine either... What version of XL are you using? If you aren't using XL 97, you shouldn't be saving in that format (unless you need backward compatibility for some reason). --JP On Mar 19, 1:57 pm, "Paul MacFarlane" <pmacfarl...@mullenlaw.com> wrote: > Thanks JP... > [quoted text clipped - 7 lines] > But having it work from the local drive indicates a network (OpLocks) > problem. Sorry, if you read that KB and tried the workaround and it still isn't fixed, there's nothing else I can suggest. --JP On Mar 19, 5:26 pm, "Paul MacFarlane" <pmacfarl...@mullenlaw.com> wrote: > XL2003... > > Not saving in that format. The person that created the file doesn't have > XLQUERY.XLA on his machine either... Thanks. Sorry, if you read that KB and tried the workaround and it still isn't fixed, there's nothing else I can suggest. --JP On Mar 19, 5:26 pm, "Paul MacFarlane" <pmacfarl...@mullenlaw.com> wrote: > XL2003... > > Not saving in that format. The person that created the file doesn't have > XLQUERY.XLA on his machine either...
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.