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?