I want to count the number of sentence parargraphs and words and character and then number of characters without spaces and report onthis into simple text boxes imagine like MS word does a wordcount i want this functonality from my VB app in a text box.
for characters without spaces do this:
YourVal = len(replace(YourText, " ", ""))
for the number of words genericaly just do this:
Tem = replace(YourText, " ", "")
YourVal = Val(Len(YourText) - Len(Tem))
MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.
In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function. While writing that article I realized that no o…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…