Jump to content
Macro Express Forums

Excel File Sharing


Recommended Posts

OK, I'm pulling my hair out, so I turn to the forum for help...


I have created a macro to run daily. It opens an Excel file each day and does some work in it. If somebody has that file open at the time the macro runs, it would be a problem, because the "File in Use" box would appear. I would like to program the macro to adapt to this. I would like it to open the file, wait 10 seconds (10 seconds is overkill, but this macro runs on days when I am not in the office, so there is no rush, and it's better to be safe than sorry), and then check to see if the "File In Use" pop-up is present. If it is, I would like it to press "N" for "Notify", and then wait indefinitely for the "File Now Available" box to appear and press "W" for Read-Write, and then continue on with what it has to do. This appears to be very simple, but I have tried 3 ways to do this, and none of them work:


1. I captured both pop-ups as Controls (The File in Use and the File Now Available Pop-up), and used


If Control %C5% Visible
Text Type: n
etc etc


2&3. I used two different Window Title Commands:


If Window Title "File in Use" is on top
Text Type: n
etc etc


If Window Title "File in Use" is running
Text Type: n
etc etc


None of these methods worked. It almost seems like the "File in Use" box freezes Macro Express completely, and will not recognize ANY MacExp commands until that box goes away. You can't even abort the macro while that box is displaying, either with SCRL LK+Pause or by right clicking the "Runner" in the system tray. If you try to abort, once you get rid of the pop-up box, it actually does abort, but it will not do it while the box is there.


It is very rare that this file will be open when the macro runs, but if it is, my PC will remain stuck in that spot for the rest of the day, and all my other daily scheduled macros will not run.


Anybody ever run into this problem? Have any ideas? Is this a bug that can be fixed?

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...