<div>
Is it possible the file is open?<br />
<br />
If it is you could check for that before trying to open it.
</div>


Is it possible the file is open?

If it is you could check for that before trying to open it.

<div>
Nope file is closed... &nbsp;Do you have a code that would check? &nbsp;If it is open display it or something? &nbsp;Right now there is nothing that indicates that it is.
</div>


Nope file is closed...  Do you have a code that would check?  If it is open display it or something?  Right now there is nothing that indicates that it is.

<div>
By checking if the file was open first it showed that I was opening the file twice. &nbsp;It was already open.<br />
Thanks for the help.
</div>


By checking if the file was open first it showed that I was opening the file twice.  It was already open.
Thanks for the help.

<div>
<div class="content wysiwyg-content">
Using the following code to open a file. &nbsp;Issue is popup alert that says the file already exists.... do I want to Save? &nbsp;Yes/No/Cancel. &nbsp;When I click Yes it does not open the file, when I press No or Cancel, I get a cannot access file?<br />
<br />
I can surpress the Alert, but the file does not open... &nbsp;when I do not surpress it is back to the alert. &nbsp;How do I get around this and just open the file up? &nbsp;Please advise and thanks. <br />
<br />

<pre><code id="code-10-28978768-1">'Application.DisplayAlerts = False
    
Workbooks.Open Filename:= _
&quot;\\nahollap548\HP-UFT\ScriptResourceFiles\ProdOrdsOperListSeq.xls&quot;</code></pre>
</div>
</div>


Using the following code to open a file.  Issue is popup alert that says the file already exists.... do I want to Save?  Yes/No/Cancel.  When I click Yes it does not open the file, when I press No or Cancel, I get a cannot access file?

I can surpress the Alert, but the file does not open...  when I do not surpress it is back to the alert.  How do I get around this and just open the file up?  Please advise and thanks. 

(CODE)

Workbooks.Open  File already exists in this location

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.