Len Question

[dvannoy]

when searching for files using a inputbox how can I use the Len command to take the length of the file name entered in the inputbox and add a .jpg extension to it?? all files searched will be .jpg format..since i am searching a file list box it shows the file extension..

thanks dvannoy@onyxes.com

 

[Shemzar]

Hi dvannoy,
assuming that the name of your search string variable is searchstr and the name of your inputbox is inputboxvalue then the following should work.

searchstr = Left(inputboxvalue, Len(inputboxvalue)) & ".jpg"

 

[dvannoy]

this is what i have...

strpath = InputBox$("Enter file name:&quot

do i set InputBox = Inputboxvalue??

thanks dvannoy@onyxes.com

 

[Shemzar]

Hi dvannoy,
No do the following

strpath = InputBox$("Enter file name:")
' check that something was entered and append .jpg
if Len(strpath) > 0 then
    strpath = Left(strpath, Len(strpath)) & ".jpg"
end if

Hope this helps.