Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Determine Excel file version with no file extension.
Our company has a ton of files with no file extensions. These are files that
were created either with Excel 2003 or 2007. We need to programmatically determine which version was used and give the file the appropriate file extension. Can anyone point me in the correct direction? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Determine Excel file version with no file extension.
I file must have an extension. You need to change the options on your windows
explorer to show extensions Tools - OPtions - Folder Options - hide extensions for know file types Unclick this option and press OK. "tjlumpkin" wrote: Our company has a ton of files with no file extensions. These are files that were created either with Excel 2003 or 2007. We need to programmatically determine which version was used and give the file the appropriate file extension. Can anyone point me in the correct direction? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Determine Excel file version with no file extension.
Just to follow up on Joel's posting...
I'm using Vista and for that Version of windows (and perhaps for XP as well, I just don't remember), after you select Folder Options, you need to select the View tab and then look in the Advanced Settings list for the "Hide extensions for know file types" and uncheck it. If you don't see a menu bar displayed (in order to be able to click the Tools item), click the Organize button in the command bar, select Layout from the drop down menu list that displays and select the Menu Bar item from its fly out menu. -- Rick (MVP - Excel) "Joel" wrote in message ... I file must have an extension. You need to change the options on your windows explorer to show extensions Tools - OPtions - Folder Options - hide extensions for know file types Unclick this option and press OK. "tjlumpkin" wrote: Our company has a ton of files with no file extensions. These are files that were created either with Excel 2003 or 2007. We need to programmatically determine which version was used and give the file the appropriate file extension. Can anyone point me in the correct direction? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
file format or file extension is not valid...error message | Excel Discussion (Misc queries) | |||
excel file extension | Excel Discussion (Misc queries) | |||
Additional file with no extension created during File Save As proc | Excel Discussion (Misc queries) | |||
how i open a file XLS extension[ exelspreadsheet file] | Excel Worksheet Functions | |||
I need to download an exel spreadsheet file. (file extension :xls) | Excel Discussion (Misc queries) |