Post method

[Guest]

Hello.
I need to create a mechanism that posts a XML file to a URL.
I have a username and password that needs to be entered so that i can access
the URL.
The idea is to send this info on the URL POST command.

Can anyone give me a hint?

Thanks.
Luis

 

[Alex Dybenko]

Hi,
you could try to use MSXML2.XMLHTTP, something like this:
http://support.microsoft.com/kb/290591/EN-US/

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[Guest]

Hi.
The XML is built using an Access DB. Is it possible to do this Post method
with Access VBA?

 

[Guest]

Hi Luis

I transfer XML files to a web site using an FTP client. I pretty certain
that VBA has nothing that allow you to do this using HTTP Post or Get
statements.

The FTP client is an ActiceX control produced by Evans FTP that is fully
programable using VBA - see http://www.evansprogramming.com/evansftp.asp

It'll cost a bit of money but well worth it.

Cheers.

BW

 

[Guest]

Hi Luis

An afterthought...

If you did want to send the XML from VBA then a possibility is to use the
FollowHyperlink method (see Help files for syntax).

You would have to create a suitable GET or POST info. string by extracting
the text from the XML file, send it, then reconstruct the XML file on the
server.

I have done this in the past but found that:

- the HTTP GET option is limited to just over 1,000 characters (which also
includes the header info. leaving 800 or so characters to play around with).
This might sound a lot but, by the time you've used space for the XML tabs
doesn't leave much. However, this may be enough for you.
- the HTTP POST option offers huge capacity but, I found anyway, is unstable
in VBA. It tends to truncate strings to the same length as the GET option or
just simply doesn't do anything!

Hope this helps.

BW