As far as i know that cannot be done. Someone else here might be able to tell
me i'm wrong, but i believe if you have another type of file with the same
name it will generate the error. Why can you not use the extension?
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"ch" wrote:

Hi All,

I received a VBA which contains the sentences that goes like :
Set WH = workbook("file1").

file1 is an excel workbook and it is open.

It worked fine most of the time. However, one of my computers shows
"subscription out of range" when I tried to execute this VBA.

My colleague changed the statement to
Set WH = workbook("file1.xls") with the extension.

It now works fine on this computer but he does not understand how it works
with the extension.

How can we set Excel such that it disregards the extension?