I have written code that involves, among other things, opening other Excel
files. Somehow a user has changed all of the Excel files to read the name
followed by .xls. As a result, the code does not accept the file names as
they are not exactly the same. There are too many references and modules to
manually change the code to match the new format. Any ideas how to reverse
the way the file names are displayed? Thanks in advance.

Are you trying to say that your file used to show up in your computer as
"MyFile", and now it shows as "MyFile.xls"?

Is it affecting all files on the computer? i.e. Word documents are
showing as WordDocument.doc, etc...?

If that is the case, someone has just flipped the system settings to
show the file name extensions. You can turn it off by going opening My
Computer, choosing Tools|Folder Options|View and checking the box for
"Hide extensions for known file types"

I'd be surprised if this was your issue though, as I would have thought
that Excel would always require these.

HTH,

Ken Puls, CMA - Microsoft MVP (Excel)
www.excelguru.ca

Chad wrote:
I have written code that involves, among other things, opening other Excel
files. Somehow a user has changed all of the Excel files to read the name
followed by .xls. As a result, the code does not accept the file names as
they are not exactly the same. There are too many references and modules to
manually change the code to match the new format. Any ideas how to reverse
the way the file names are displayed? Thanks in advance.

Thank you very much. This fixed the issue.

"Ken Puls" wrote:

Are you trying to say that your file used to show up in your computer as
"MyFile", and now it shows as "MyFile.xls"?

Is it affecting all files on the computer? i.e. Word documents are
showing as WordDocument.doc, etc...?

If that is the case, someone has just flipped the system settings to
show the file name extensions. You can turn it off by going opening My
Computer, choosing Tools|Folder Options|View and checking the box for
"Hide extensions for known file types"

I'd be surprised if this was your issue though, as I would have thought
that Excel would always require these.

HTH,

Ken Puls, CMA - Microsoft MVP (Excel)
www.excelguru.ca

Chad wrote:
I have written code that involves, among other things, opening other Excel
files. Somehow a user has changed all of the Excel files to read the name
followed by .xls. As a result, the code does not accept the file names as
they are not exactly the same. There are too many references and modules to
manually change the code to match the new format. Any ideas how to reverse
the way the file names are displayed? Thanks in advance.