Tags » Vba

New paragraph in MS Word VBA

In a MS Word document, how can you do to create a new paragraph with a VBA? As for me, there are two simple ways. 266 more words

Paragraph

number to words

Option Explicit
'Main Function
Function SpellNumber(ByVal MyNumber)
Dim Dollars, Cents, Temp
Dim DecimalPlace, Count
ReDim Place(9) As String
Place(2) = " Thousand "
Place(3) = " Million "
679 more words

Vba

outlook self bcc

Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean)
Dim objRecip As Recipient
Dim strMsg As String
Dim res As Integer
Dim strBcc As String…
86 more words

Vba

From the Labs: VBA is definitely not dead - in fact, it's undergoing a resurgence

Earlier this year, Principal Researcher at SophosLabs, Gabor Szappanos (Szappi) published an excellent paper, “VBA is not dead“, on the re-emergence of Visual Basic code in malicious documents. 1,840 more words

Featured

Using named ranges and worksheet functions in Excel VBA

Bold Brackets

A couple of days ago I saw something in an article on StackOverflow, that blew my mind. I can’t find the article anymore, but I do remember what this one neat trick was, that will for ever change your VBA. 570 more words

Programming