Need to Bypass or Disable 'File in Use' Error Message on Personal.xlsb File

TMabry

New Member
Joined
Jul 14, 2016
Messages
2
Hello,

The Personal.xlsb Macro file on my system is set to open automatically when Excel Opens (in the XLSTART folder) and is hidden from view, so that it is accessible for me to code and write to without having to manually open it.

Normally, this is not an issue, but it has been an on again / off again problem with automated processes that open multiple windows in Excel.

The issue starts when I have an Excel Window already loaded, and an automated process (from MS Scheduler) runs and opens another Excel Window on top of the one I am working on. Excel attempts to load and access the Personal.xlsb file in the new window only to find it is use by of course the original window I have open.

This is important for a couple of reasons: (1) I need these separate processes to run in their Excel Windows and I need to bypass that warning if for some reason Excel fails to close, but has a process open (visible to Task Manager), or I actually working on another spreadsheet.

Question: Is there way I can force Excel to ignore the other Excel Windows running, and open the personal.xlsb file as "Read Only" or "Notify" thereby bypassing the warning message that halts the automation?

I have DDE unchecked. And I have tried to check for an open instance of the personal.xlsb file, and make it Read-Only. Neither solves the issue. A work-a-round (this is really *not* ideal) is to make the Personal.xlsb file a Shared File. This solves the problem, but every time I would need to write to it, I have to unshare it. Too big of hassle.

Thanks in advance for suggestions or you code that will help me resolve this.
 

Forum statistics

Threads
1,081,690
Messages
5,360,614
Members
400,592
Latest member
badgergurl

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top