Capitalize When File Opens 1

[ckugo]

Hello everyone.

I am recieving a file from an outside source that is unable to format the file the way I need it. I really need a couple columns to be all upper case. I have found ways to do this when the text in the cell changes and so on, but I cannot seem to find a way to make these automatically change into upper case when the file opens. This is in Excel 2002. Does anyone have any ideas??

Thanks,

Chris

 

[PHV]

Perhaps some code in the Workbook_Open event procedure ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[ckugo]

You will have to forgive me, as I am not to VBA fluent but I do know the basics. Here is the code that I am using, courtesy of

http://www.MrExcel.com:

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Columns("C")) Is Nothing Then
Target = Format(Target, ">")
Else
End If
End Sub

I am trying to call this sub from some of the other procedures, and it is not working. Any more ideas??

Thanks for the quick reply,

Chris

 

[GlennUK]

What about you running a macro on this file after you open it?

Sub changetoupper()
    For Each c In ActiveSheet.Range("C1:C200")
        c.Value = UCase(c.Value)
    Next
End Sub

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[ckugo]

Thanks so much Glenn, that did exactly what I needed.

Thanks again,

Chris