XLS File
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. |
XLS File
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. |
XLS File
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. |
All times are GMT +1. The time now is 10:09 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com