VBA Workbooks.Open - If Already Open?

[cr731]

If I use

Workbooks.Open "My File Name"

and the workbook is already open, will it re-open the file (wasting time for a large file) or will it just do nothing since the file is already open?

I tried running Workbooks.Open ThisWorkBook.FullName in the immediate window and it seems like nothing happens, but I want to double check, since I've seen a lot of code out there for opening a file only if it's not already open.

Thanks

 

[Joe4]

If you do a Google Search on "excel vba see if file is open before opening site:mrexcel.com", you will find lots of past threads on this site that deal with that issue, and different ways of approaching them.

 

[cr731]

If you do a Google Search on "excel vba see if file is open before opening site:mrexcel.com", you will find lots of past threads on this site that deal with that issue, and different ways of approaching them.

Thanks; I did do some similar searches before posting but I guess my question really is, does it matter if the workbook is already open before running Workbooks.Open? I found lots of questions around how to determine if the workbook is open, I'm just trying to understand if there is a negative performance reason for running Workbooks.Open on an already open workbook.