View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jarle Jarle is offline
external usenet poster
 
Posts: 32
Default 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