VBA Code not working in 2007

blue9244 · August 18th, 2009, 04:18 PM

I have recently installed Office 2007. I have a program used by more than just myself and I'm getting errors such as "Can't find project or library" and the code highlights both "UCase" and "Trim" so far. Are these functions no longer used in 2007? I have to be able to run the code for production purposes and I'm not sure how to work around this problem. This "program" was something I created quite a few years ago under a much earlier version of Excel and I've never had a problem running this particular code over the years until now. Any help would be appreciated. A sample is below:

Code:

 With Range("E5:F7")
        .Merge
        .HorizontalAlignment = xlCenter
        .VerticalAlignment = xlCenter
        .WrapText = True
        .Font.Name = "Arial"
        .Font.Size = 9
        .Formula = _
        "ONE (1) " & Worksheets("Misc Calcs").Range("BF37").Text & " " & UCase  (Worksheets("Cust Info").Range("C18").Text) & " VIBRATING CONVEYOR"
    End With

The code halts at UCase...

Thanks much!

Shasur · August 19th, 2009, 01:33 AM

Hi

Both these functions are Part of VBA's String class

Can you try using Strings.UCase etc

Cheers
Shasur

blue9244 · August 19th, 2009, 09:59 AM

That did the trick! I wonder why it's now necessary to add the class when it wasn't required in previous versions of Excel. Any ideas? I had the same problem with Date and had to add DateTime to make it work.

Thanks very much for the suggestion and solution! You rock!

Shasur · August 20th, 2009, 03:16 AM

Hi

Was there any multiple versions of Office installed in your machine? This might be one possible cause of the problem. The other might be version difference between the referenced DLLs

Cheers
Shasur

blue9244 · August 20th, 2009, 09:11 AM

Well I did have a trial version installed initially and then I upgraded it to the full version. Perhaps that was the cause. I don't know anything about the DLL versions...

Thanks very much for our help!