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

[pgag45]

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

[pgag45]

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?

[pgag45]

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

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

[pgag45]

meh figured it out...

had to put VBA.Mid(...

or VBA.UCase(...