Suppress macros start up folder possible?

[dispelthemyth]

In the advanced Excel option you can select a folder which will have all files open when You 1st open Excel.
The problem is I have some vba that opens up new instances of Excel (intentionally) but each instance of Excel will try to open these files too but as they are open they get a read only message.
Is it possible to to suppress this folder, startup or to access the option via Vba so I can set it to be nothing before I open a file and revert it to the original option afterwards.

 

[GWteB]

Something like this?

    Dim oXLapp as Application
    Dim sOldPath as String
    ' prevent opening workbooks on startup
    sOldPath = Application.AltStartupPath
    Application.AltStartupPath = ""
    ' launch a separate instance
    Set oXLapp = New Application
    oXLapp.Visible = True
    Application.AltStartupPath = sOldPath
    ' rest of your code ....

 

[Peter_SSs]

Another option would be to modify the code that opens the workbook to first check if they are already open.
Then the first time that code runs it will open the files but subsequent times it will not try.

 

[dispelthemyth]

Another option would be to modify the code that opens the workbook to first check if they are already open.
Then the first time that code runs it will open the files but subsequent times it will not try.

Such an elegant and simple thing to do, thanks for the advice. I’m embarrassed I didn’t think of this.

 

[Peter_SSs]

You're welcome.

 

[dispelthemyth]

Something like this?

    Dim oXLapp as Application
    Dim sOldPath as String
    ' prevent opening workbooks on startup
    sOldPath = Application.AltStartupPath
    Application.AltStartupPath = ""
    ' launch a separate instance
    Set oXLapp = New Application
    oXLapp.Visible = True
    Application.AltStartupPath = sOldPath
    ' rest of your code ....

Thank you for taking the time to post this code. This solution is great, I checked through the Application directory and didn’t see that option. I’ll check twice next time.