initial capital
PROPER Excel function converts all the words of the string passed as its argument in lower case with capitalized words ... is not very useful except for a list of names and surnames.
The function (UDF also) that I propose to convert a text extended to comply with certain rules of grammar. The text passed as an argument it is changed only in the beginning letters of words, letters, following a carriage return and in the letters that follow a period, exclamation point and a question mark. Following a routine to test the result. Would it be possible
do the trim first or conversion lcase ... but if you want, in fact, if you want you can do before passing the argument to the function. Greetings
r
MaiuscoInizialeMigliorato Function (
_ ByVal s As String) As String '
'__________________________________________
¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
'by Robert Mensa nick r
'__________________________________________
' ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
Dim v, i As Long
Dim re As Object
Set re = CreateObject("vbscript.regexp")
re.Pattern = _
"(^ _
"lowercase." & _ VbNewLine & _
"become the tiny capital"
& _ "if a sentence begins!" & _ VbNewLine & _
"become the tiny capital" & _
"after a point, point" & _
"exclamation or a question mark" & _ vbNewLine & _
"the become sensitive case "& _
" after a break. "
MsgBox s, vbOKOnly, "before"
MaiuscoInizialeMigliorato MsgBox (s),
_ vbOKOnly, "After" End Sub
Tuesday, January 12, 2010
Monday, January 11, 2010
How To Hack Poptropica For Credits
Cavandoli improved test ... the second test with expert Excel
's colleagues and friends coming for the second Cavandoli Test ... download the file at this link
fun :-) greetings
r
ps
then scroll to the bottom there is also a portrait of me :-) I had to paint by hand
nearly 100,000 cells
you believe it? :-)
's colleagues and friends coming for the second Cavandoli Test ... download the file at this link
fun :-) greetings
r
ps
then scroll to the bottom there is also a portrait of me :-) I had to paint by hand
nearly 100,000 cells
you believe it? :-)
Friday, January 8, 2010
Naruto Futanari Kokoro Tenshin
Strange Attractors (Peter de Jong - Excel Charts)
few days ago nell'NG excel, Joan asked if we could see a strange attractor in excel. I honestly did not even know what they were ... so I followed the link where you explained what they were (
link to Wikipedia, and others ... few days ago nell'NG excel, Joan asked if we could see a strange attractor in excel. I honestly did not even know what they were ... so I followed the link where you explained what they were (
link, link2
).
Soon I am passionate about this game of twists and randomness ... so I prepared a folder Excel which allows you to * play * in the true sense of the word, the curves of Peter de Jong ... Then I found a version and I have invented two more (the number 3 and 4) the right to make the game more varied
:-) The file that you can download by clicking here
(the file contains macros to be saved and to avoid errors in carrying out the same) you will find everything you need to create random sets, save the most beautiful, automatically create charts of different colors and with different number of points ... from 10,000 to 200,000 ... you should play with a set of 10,000 points for any increase after the number of points, this will allow for quick updates or see the graph as a result returns the same series with the variants 2, 3 or 4. An example
the link
discussion nell'NG
the link in the youth blog
Greetings
r
Monday, January 4, 2010
Flat Irons For Hair/ J C Penney
Currency Converter (Add-in Excel 2003)
I am surviving the holiday season :-)
What I propose is a tool for converting currencies.
The add-in can be downloaded by clicking here
.
on how and where to save the add-in to see the Help section:
"Troubleshooting add-ons"
Once the file is saved you can add references from the menu Tools-> Add-ons ... if you can use the Browse button to locate the file. 
The drive uses a connection via Internet Explorer to Google, then launches a search through the use of keywords recovering the result of Google's calculator tool ...
an example can easily illustrate what happens ... this is a string that can perform a search in google type convert a euro in U.S. dollars:
http://www.google.it/search?q=1+EUR+in+USD
page that opens you will see the result at the top of the instrument calculator google ... that number is what is recovered as a result of the conversion from the add ... :-)
In this way we delegate to update the Google index conversion ... a heartfelt thanks :-)
Once you add the component to open Excel will create a toolbar is not anchored with a button to display the Form of the drive.
Combo are displayed in two lists of currencies used in the conversion. In the first column you will find the 3-letter code that refers to the currency (eg EUR for the euro), the currency name in the second and third countries in which it is used.
clicking on the column headers to sort you get alternately increasing and decreasing respect for each click on the title you want to sort.
close the form the conversion result is copied into memory, so it is available to be pasted into the cell.
not choosing any value from the second combo, the conversion will happen in the defoult €.
It 'goes without saying that for it to work properly Internet Explorer must be installed and the computer must be connected to the Internet.
The VBA project is not protected, the code is not commented, although it will be easy to understand how it works.
What about ... fun
Greetings
r
ps
clicking here you can download the workbook (xls) ... as you can then save as Excel add-in, so the xla file is automatically saved to the folder which contains the AddIns
I am surviving the holiday season :-)
What I propose is a tool for converting currencies.
The add-in can be downloaded by clicking here
.
on how and where to save the add-in to see the Help section:
"Troubleshooting add-ons"
Once the file is saved you can add references from the menu Tools-> Add-ons ... if you can use the Browse button to locate the file.
The drive uses a connection via Internet Explorer to Google, then launches a search through the use of keywords recovering the result of Google's calculator tool ... an example can easily illustrate what happens ... this is a string that can perform a search in google type convert a euro in U.S. dollars:
http://www.google.it/search?q=1+EUR+in+USD
page that opens you will see the result at the top of the instrument calculator google ... that number is what is recovered as a result of the conversion from the add ... :-)
In this way we delegate to update the Google index conversion ... a heartfelt thanks :-)
Once you add the component to open Excel will create a toolbar is not anchored with a button to display the Form of the drive.
Combo are displayed in two lists of currencies used in the conversion. In the first column you will find the 3-letter code that refers to the currency (eg EUR for the euro), the currency name in the second and third countries in which it is used.
clicking on the column headers to sort you get alternately increasing and decreasing respect for each click on the title you want to sort.
close the form the conversion result is copied into memory, so it is available to be pasted into the cell.
not choosing any value from the second combo, the conversion will happen in the defoult €.
It 'goes without saying that for it to work properly Internet Explorer must be installed and the computer must be connected to the Internet.
The VBA project is not protected, the code is not commented, although it will be easy to understand how it works. What about ... fun
Greetings
r
ps
clicking here you can download the workbook (xls) ... as you can then save as Excel add-in, so the xla file is automatically saved to the folder which contains the AddIns
Subscribe to:
Posts (Atom)