It is soo true that if you work for a startup you end up wearing multiple hats. I work for a very small startup and I wear more hats that the Queen of England. One of those hats is of a Visual Basic developer. Most business applications are not fancy or web two point ooh-y, they usually involve some charts, some graphs, and some integration with Microsoft Office<\/b> products.<\/p>\n
As most script kiddies know, with a little Visual Basic code you can write scripts to open, write, and send emails, generate excel documents, print word documents, and so much more. Fore example, here is a little bit of vbs code to automate the send button (now if you can automate running the script):<\/p>\n
[source:vbs]
\nSet objOutlook = CreateObject(“Outlook.Application”)
\nSet objNamespace = objOutlook.GetNamespace(“MAPI”)<\/p>\n
‘ Need to have open a new email window for the following
\nSet objInspector = objOutlook.ActiveInspector
\nSet objMailItem = objInspector.CurrentItem<\/p>\n
‘ Send the email, after the user presses the okay
\n‘ button on the confirmation dialog
\nobjMailItem.Send
\n[\/source]<\/p>\n
Now, if you want to pop up a message dialog with the subject of the last email you received, just run the following lines of code:<\/p>\n
[source:vbs]
\nConst olFolderInbox = 6
\nConst olFolderSentMail = 5<\/p>\n
Set objOutlook = CreateObject(“Outlook.Application”)
\nSet objNamespace = objOutlook.GetNamespace(“MAPI”)<\/p>\n
Set objFolder = objNamespace.GetDefaultFolder(olFolderSentMail)
\nMsgBox “Subject: ” & objFolder.Items.GetLast.Subject
\n[\/source]<\/p>\n
I have a few more example of Visual Basic code manipulating Microsoft Office products here<\/a>. If you want to run similar COM code but in Java you can do so using Groovy<\/b> and Scriptom<\/b>. I have already mentioned Scriptom before so I will refer you to that post<\/a>.<\/p>\n Technorati Tags: scriptom<\/a>, groovy<\/a>, java<\/a>, com<\/a>, visual basic<\/a>, outlook<\/a>, scripts<\/a>, visual basic script<\/a><\/p>\n","protected":false},"excerpt":{"rendered":" It is soo true that if you work for a startup you end up wearing multiple hats. I work for a very small startup and I wear more hats that the Queen of England. One of those hats is of a Visual Basic developer. Most business applications are not fancy or web two point ooh-y, […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"spay_email":"","footnotes":""},"categories":[15,3,5],"tags":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p902K-2C","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/juixe.com\/techknow\/index.php\/wp-json\/wp\/v2\/posts\/162"}],"collection":[{"href":"http:\/\/juixe.com\/techknow\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/juixe.com\/techknow\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/juixe.com\/techknow\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/juixe.com\/techknow\/index.php\/wp-json\/wp\/v2\/comments?post=162"}],"version-history":[{"count":0,"href":"http:\/\/juixe.com\/techknow\/index.php\/wp-json\/wp\/v2\/posts\/162\/revisions"}],"wp:attachment":[{"href":"http:\/\/juixe.com\/techknow\/index.php\/wp-json\/wp\/v2\/media?parent=162"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/juixe.com\/techknow\/index.php\/wp-json\/wp\/v2\/categories?post=162"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/juixe.com\/techknow\/index.php\/wp-json\/wp\/v2\/tags?post=162"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}