Hi all, hoping someone can help with this:
Using the Set command (xl2003) to open a Shared Workbook, (or re-open if already in use, as it usually is, being a Shared file and all), to grab some data for my project. The code shown below works fine, [both WITH and WITHOUT the shared file already being opened in my session, ...however, when other users run the same code, it errors out, complaining that the file is already open, and that you can not have (2) instances of the same file open at the same name.
With DisplayAlerts being False, the warning about re-opening a file already open should be overridden, and the file should close, and re-open without issue, as it does on my machine. (Users in question have same admin privileges to the directory as I do).
Anyway, I am stumped, here's the section of code giving me grief. Note: it is the "Set dbWB3 = Workbooks.Open(dbFPath2 & "\" & dbFName2)" line that it errors on. If anything jumps out, please advise!
Bookmarks