Excel Extensions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Excel uses a windows setting
In winXP Home:
Open windows explorer
Tools|Folder Options|View tab
check "hide extensions for known file types"
(this is a user by user setting, too!)

But this will tick most users off--it would me! I always want to see the
extensions.

You'll be better off if you change the code to always include the extension.

I don't think you'll be able to control users to leave this setting the way you
want.
 
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subscript out of range Error 2
File extensions 3
Merging 800 Excel files 1
Excel Open Error 7
Drop down list as part of a file name selector 1
how to keep formula don't changed when I copy the file the folder 1
Removing file extensions on e-mail 1
Creating duplicates accidentally 1

Back
Top