vba file name

[plost33]

I have a the following line of code that assigns a selected file in a list box to a variable.

FileToOpen = ListBox1.Value


I now need to assess the file name selected. If the first three letters of the file name are "Con" the i want to put "Sub" in cell S1. if the letters are not "CON" then i want to put "EE" in cell S1.

 

[plost33]

here is what i have thus far, with no success:

FileType = if (left(filetoopen,3)="Con","Sub","EE")


i want to assign either "sub" or "ee" tot he variable FileType based ont eh first three letters of the variable FileToOpen.

 

[Giordano Bruno]

Does this work?

FileType = "EE"
If(left(FileToOpen, 3) = "Con" then FileType = "Sub"

 

[plost33]

worked great! thanks