cdbrown
06-30-2006, 01:18 AM
Hi - Is it possible to capitalise the text in a cell. I'm using a portion of a filename (wb3) as part of the saved name of wb2.
To capture the part I want
Sheets("List").Select
ActiveSheet.Cells(9, 3).Value = Mid(wb3.Name, 19, Len(wb3.Name) - 37)
returns stuff like i04x-g but I need it to be I04X-G when using it in the filesave
ActiveWorkbook.SaveAs Filename:="Toxic Gas - " & Cells(9, 3)
Any way to force it to be capitals during the capture, filesave or somewhere else?
Cheers
-cdbrown
PS - I'm sure there's more questions to come
To capture the part I want
Sheets("List").Select
ActiveSheet.Cells(9, 3).Value = Mid(wb3.Name, 19, Len(wb3.Name) - 37)
returns stuff like i04x-g but I need it to be I04X-G when using it in the filesave
ActiveWorkbook.SaveAs Filename:="Toxic Gas - " & Cells(9, 3)
Any way to force it to be capitals during the capture, filesave or somewhere else?
Cheers
-cdbrown
PS - I'm sure there's more questions to come