• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. G

    Check for any open workbooks

    SirJB7, thanks for the help. Unfortunately I'm not good with vba. I can code enough to put a formula in a cell, but thats about it. . I haven't really explained myself well (I'm typing on a phone and trying to be too quick. Basically, I've inherited a system that checks a specific folder and...
  2. G

    Check for any open workbooks

    Thanks for your reply Narayan. The problem is the workbooks within th folder are constantly changing between each update. There will be a maximum of 30 but there could be as few as 7 each with a unique filename. There is no set list of files. What I need is to be able to loop through the...
  3. G

    Check for any open workbooks

    I have a spreadsheet that is updated by over 30 workbooks at the press of a button. The problem is that if any of those workbooks are open the code crashes. What I'd like is for a piece of code that will loop through the folder containing the workbooks and display a message if it finds an...
Back
Top