You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@esme.apache.org by rh...@apache.org on 2011/07/17 17:20:58 UTC
svn commit: r1147655 - /esme/site/trunk/content/docs/clients/vba.mdtext
Author: rhirsch
Date: Sun Jul 17 15:20:56 2011
New Revision: 1147655
URL: http://svn.apache.org/viewvc?rev=1147655&view=rev
Log:
CMS commit to esme by rhirsch
Modified:
esme/site/trunk/content/docs/clients/vba.mdtext
Modified: esme/site/trunk/content/docs/clients/vba.mdtext
URL: http://svn.apache.org/viewvc/esme/site/trunk/content/docs/clients/vba.mdtext?rev=1147655&r1=1147654&r2=1147655&view=diff
==============================================================================
--- esme/site/trunk/content/docs/clients/vba.mdtext (original)
+++ esme/site/trunk/content/docs/clients/vba.mdtext Sun Jul 17 15:20:56 2011
@@ -1,8 +1,9 @@
Title: VBA
+
Many people spend most of the day either working on SAP-related systems or
on Microsoft Office products. We have created a VBA macro that
creates messages on EMSE for those individuals who work with Excel and
-Word. This macro is based on ESME's [REST API](https://cwiki.apache.org/confluence/display/ESME/RESTAPI)
+Word. This macro is based on ESME's [REST API](/docs/apis/original-api.html)
.
The macro pops up in your Office tool of choice which allows you to enter a
@@ -13,40 +14,41 @@ To authenticate themselves, ESME users m
currently hard-coded as well.
-Sub ESME_sendMessage()
-
-âHTTP variable
-Dim myHTTP As MSXML2.XMLHTTP
-
-âHTTP object
-Set myHTTP = CreateObject(âmsxml2.xmlhttpâ)
-
-âopen the connection
-myHTTP.Open âpostâ, _
-â[http://api.esme.us/esme/api/login?token=[insert_your_token](http://api.esme.us/esme/api/login?token=[insert_your_token)
-|http://api.esme.us/esme/api/login?token=[insert_your_token]]â, False
-
-âsend
-myHTTP.Send
-
-â Send Message
-
-Dim message
-
-message = InputBox(âEnter Messageâ)
-
-myHTTP.Open âpostâ, _
-â[http://api.esme.us/esme/api/send_msg?message](http://api.esme.us/esme/api/send_msg?message)
-=â + message + â&tags=Test,excel&via=excelâ, False
-
-âsend
-myHTTP.Send
-
-âLogout
-myHTTP.Open âgetâ, _
-â[http://api.esme.us/esme/api/logout](http://api.esme.us/esme/api/logout)
-â, False
+ Sub ESME_sendMessage()
+
+ âHTTP variable
+ Dim myHTTP As MSXML2.XMLHTTP
+
+ âHTTP object
+ Set myHTTP = CreateObject(âmsxml2.xmlhttpâ)
+
+ âopen the connection
+ myHTTP.Open âpostâ, _
+ â[http://api.esme.us/esme/api/login?token=[insert_your_token](http://api.esme.us/esme/api/login?token=[insert_your_token)
+ |http://api.esme.us/esme/api/login?token=[insert_your_token]]â, False
+
+ âsend
+ myHTTP.Send
+
+ â Send Message
+
+ Dim message
+
+ message = InputBox(âEnter Messageâ)
+
+ myHTTP.Open âpostâ, _
+ â[http://api.esme.us/esme/api/send_msg?message](http://api.esme.us/esme/api/send_msg?message)
+ =â + message + â&tags=Test,excel&via=excelâ, False
+
+ âsend
+ myHTTP.Send
+
+ âLogout
+ myHTTP.Open âgetâ, _
+ â[http://api.esme.us/esme/api/logout](http://api.esme.us/esme/api/logout)
+ â, False
+
+ âsend
+ myHTTP.Send
+ End Sub
-âsend
-myHTTP.Send
-End Sub