Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

.xls Extension needed in Filename

Status
Not open for further replies.

Westicle

Programmer
Aug 22, 2002
29
GB
Some of my macros that have been running fine for the last few months have stopped working rescently. I have worked out that it is because they now require .xls at the end of a filename where previoulsy they had not. I don't know what i have changed (nothing to my knowledge) but i am getting error messages without the Ext. My concern is that something has changed without my own obvious 'doing' that has caused the macros to stop working.
e.g.

Workbooks("CONSOLIDATION").Worksheets("Sheet1").Activate
now requires
Workbooks("CONSOLIDATION.xls").Worksheets("Sheet1").Activate
for it to work.

Does anybody know why??
 
Windows Explorer settings

"Hide file extensions for known file types"

you had it 'off' but now it is 'on'

or for the "Excel files" file type, you have the "always show extension" checked
 
Thanks, i was starting to lose my sanity wondering if it had worked before or not!!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top