| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check if file is excel file
I have ha file with filemame FName (that includes the complete path)
If FName is an excel file Then x=A Else x=B How can I check if FName is an excel file? rgds Jarle |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Check if file is excel file
Hi
If LCase(Right(FName, 3)) = "xls" Then x = "A" Else x = "B" End If Regards, Per "Jarle" skrev i meddelelsen ... I have ha file with filemame FName (that includes the complete path) If FName is an excel file Then x=A Else x=B How can I check if FName is an excel file? rgds Jarle |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Check if file is excel file
Thanks!
Per Jessen skrev: Hi If LCase(Right(FName, 3)) = "xls" Then x = "A" Else x = "B" End If Regards, Per "Jarle" skrev i meddelelsen ... I have ha file with filemame FName (that includes the complete path) If FName is an excel file Then x=A Else x=B How can I check if FName is an excel file? rgds Jarle |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Check Excel file for Corruption? | Excel Discussion (Misc queries) | |||
| Check if a sheet exists in a file, without opening that file | Excel Programming | |||
| code to check file size everytime an Excel file is opened | Excel Programming | |||
| Check to see if excel file has been saved | Excel Programming | |||
| How to check Excel file already Open | Excel Programming | |||
Linear Mode
