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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel saving files without extension

Status
Not open for further replies.

flaviooooo

Programmer
Joined
Feb 24, 2003
Messages
496
Location
FR
Hi,

I'm having a strange occurance here with some excelfiles. In them is some code where it saves the file to another location. On all pc's it works, except 1. On this one the file is saved without a file extension?

Can you explain what could be the cause of this? Is there maybe some kind of setting that's wrong?

The code is:
ActiveWorkbook.SaveAs FileName:=(Naam)

(naam) is the field containing the filename (without xls)

 
Hi,
Maybe it's this: In My Computer, Tools/Folder Options/View Tab, there's a list in the window and "Hide extensions for known file types" is a choice. If it's checked, then extensions won't appear.
HTH,

Best,
Blue Horizon [2thumbsup]
 
No, that's not it unfortunately.

All file extensions are shown, and you can also see that the icon of the created file is different. When you try to open it, it asks which program you want to use.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top