[RESOLVED] update from 2003... Mid() function

Hey all,

Just updating a 2003 workbook to 2007 ... and running into something I can't figure out.

I have the exact same references in both my 2003 and 2007 version, but for some reason the following code won't compile "with object/library missing" (as I said all the same references though)...

temp = Mid$(FileName, x, 1)

so I tried
temp = Mid(FileName, x, 1)

doesn't work either..

any suggestions?

thanks much

why I say same refs... obviously the excel and vba object libraries went to 12.0 from 11.0.

did the Mid function change or something?

turns out for other stuff like UCase() and other string manip

guess my question is what library does the string manipulation come from?

meh figured it out...

had to put VBA.Mid(...

or VBA.UCase(...