Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need Applescript for Converting Upper/Lower Case
hi,
i have a situation where i frequently receive xls files with lots o text written in ALL CAPS. i need for that text to use "proper capitalization (Title Case would be an adequate alternative, and lowe case would be a last resort.), but am looking to avoid lots of typing. i'm on mac osx, and believe i'd prefer an applescript solution. i'v dabbled a bit in applescript but don't know enough to pull this on off. an applescript would also be excellent because i figure i coul probably modify it without too much trouble, to work with othe applications. if there is a non-applescript solution, i'd be interested to know tha as well. i could also make use of a PC solution, such as a VBscript if necessary. thanks! jo -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need Applescript for Converting Upper/Lower Case
Here is something that will work that I found in an example ages ago.
Can't remember who developed it Sub ConvertToTitle() Dim wks As Worksheet Dim rngCell As Range Dim iCols As Integer Dim iRows As Integer For Each wks In Sheets With wks.UsedRange For iCols = 1 To .Columns.Count For iRows = 1 To .Rows.Count Set rngCell = .Cells(iRows, iCols) If Not rngCell.HasFormula Then _ rngCell.Value = StrConv(rngCell.Text, 3) Next iRows Next iCols End With Next wks End Sub "Br0wn Recloose " wrote in message ... hi, i have a situation where i frequently receive xls files with lots of text written in ALL CAPS. i need for that text to use "proper" capitalization (Title Case would be an adequate alternative, and lower case would be a last resort.), but am looking to avoid lots of typing. i'm on mac osx, and believe i'd prefer an applescript solution. i've dabbled a bit in applescript but don't know enough to pull this one off. an applescript would also be excellent because i figure i could probably modify it without too much trouble, to work with other applications. if there is a non-applescript solution, i'd be interested to know that as well. i could also make use of a PC solution, such as a VBscript, if necessary. thanks! jon --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need Applescript for Converting Upper/Lower Case
looks good, i'll give this a whirl next time i'm near a PC! if anybody
has an applescript equivalent that would be great. thanks, jon --- Message posted from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need Applescript for Converting Upper/Lower Case
You can use applescript - it depends on what version of XL you're using
- XL04 exposes the entire Excel object model to applescript, XLv.X doesn't. But you don't need to have a PC to use VBA (which is what David Adamson gave you) - All current versions of MacXL use VBA, for the most part compatible with WinXL. In article , Br0wn Recloose wrote: looks good, i'll give this a whirl next time i'm near a PC! if anybody has an applescript equivalent that would be great. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting upper case to lower case | Excel Discussion (Misc queries) | |||
Changing upper case characters to upper/lower | Excel Discussion (Misc queries) | |||
Changing file in all upper case to upper and lower case | Excel Discussion (Misc queries) | |||
Change from mixed caps and upper lower to all upper lower case | Excel Worksheet Functions | |||
How do I convert all upper case excel sheet into upper and lower . | Excel Discussion (Misc queries) |