definitely perform the HTTP aspects of this in a Windows Scripting Host
container. I would assume this would be possible in the macro (using VBA).
To do this you'd use the Microsoft.XMLHTTP object (this comes with IE 6 -
older versions of IE have the same object, but use different names).
For example:
// Init the HTTP object
var HTTPGetter = new ActiveXObject("Microsoft.XMLHTTP");
// Init the HTTP Object
HTTPGetter.Open( "GET", "HTTPS://www.yourdomain.com/", false );
HTTPGetter.Send();
You would then access the content returned with HTTPGetter.responseText;
That's a GET, but you can also do POSTs as well (although I can't remember
how off the top of my head).
The same package that contains the HTTP object also contains the MSXML
object which will let you do all your XML stuff easily.
You don't need to know VB (at least as far as I know) - you can do
everything in Jscript. So, basically, if you know _javascript_ you can do web
pages, Windows Scripting, Action Scripting, Test Director scripting and lots
of other stuff - it's all over the place. ;^)
Jim Davis
_____
From: Jim Campbell [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 01, 2004 4:57 PM
To: CF-Community
Subject: Office Macro HTTP?
I've got a quick question. We've clients who use a macro we provide for
Excel to output data into a regular format for them to plug into a file
upload widget on our website, which parses it and makes sure all the
records are good. Well, we'd like to streamline it a little, and since
I'm not a VB/Macro nerd by any stretch of the imagination, I was
wondering if I could safely invoke an HTTPS connection through an
Excel/Office macro? I'm thinking the execution would be like this:
1) Excel document created - macro button pressed.
2) Macro creates structured data (XML maybe), stores it in memory
3) Macro invokes HTTPS connection, authenticates user, sends data
4) Macro closes connection, sends user a joyous success message
5) And they ate Sir Robin's Minstrels
Is this possible, or would I be wrangling with way too many
system/access permissions to even be considering something like this?
- Jim
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
