+ Reply to Thread
Results 1 to 4 of 4

loop counter not recognised

  1. #1
    Forum Contributor Dave H9's Avatar
    Join Date
    03-10-2011
    Location
    Manchester, England
    MS-Off Ver
    Excel 2007
    Posts
    418

    loop counter not recognised

    Please can someone help with the below code? I am trying to write this to check whether a workbook is already open by another user but it gets stuck in the loop and ignores (or more probably my code is wrong) the counter which should cause an "Exit Do" at a value of two -

    Please Login or Register  to view this content.
    Also I realise this is perhaps the wrong approach for my solution. Is there a way of determing read only status without opening the workbook?

    Many thanks

    Dave
    Last edited by Dave H9; 05-13-2011 at 02:53 AM.

  2. #2
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: loop counter not recognised

    See if this simplfied code works any better

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor Dave H9's Avatar
    Join Date
    03-10-2011
    Location
    Manchester, England
    MS-Off Ver
    Excel 2007
    Posts
    418

    Re: loop counter not recognised

    Thank you Bob,

    I will give it a try when I'm back on network.

    Any suggestions for solution without trying to open workbook?

  4. #4
    Forum Contributor Dave H9's Avatar
    Join Date
    03-10-2011
    Location
    Manchester, England
    MS-Off Ver
    Excel 2007
    Posts
    418

    Re: loop counter not recognised

    Thanks Bob the modifactions work a treat.

    This site never lets me down!

    Thanks again

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1