A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Writing data on a XML file on internet



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old December 11th 07, 07:21 PM posted to microsoft.public.outlook.program_vba
Jpgoyen
external usenet poster
 
Posts: 8
Default Writing data on a XML file on internet

Hello,

I am still a beginner in VBA...
I am searching a way to write/modify data in a xml file on internet from a
macro in Outlook.
I found a way, with CreateObject("MSXML2.XMLHTTP") and get method, to read
some text data in a file, or get the whole file, but didn't find any way to
write in a web file from my macro.
Has anyone already used the POST method in VBA, getting the right syntax
would help me a lot.


Thank you very much for your help or reference

Jean-Philippe
Ads
  #2  
Old December 12th 07, 05:25 PM posted to microsoft.public.outlook.program_vba
Eric Legault [MVP - Outlook]
external usenet poster
 
Posts: 830
Default Writing data on a XML file on internet

Where exactly is this file? In an FTP directory? A server side file in a
web application?

--
Eric Legault - Outlook MVP, MCDBA, MCTS (SharePoint programming, etc.)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/


"Jpgoyen" wrote:

Hello,

I am still a beginner in VBA...
I am searching a way to write/modify data in a xml file on internet from a
macro in Outlook.
I found a way, with CreateObject("MSXML2.XMLHTTP") and get method, to read
some text data in a file, or get the whole file, but didn't find any way to
write in a web file from my macro.
Has anyone already used the POST method in VBA, getting the right syntax
would help me a lot.


Thank you very much for your help or reference

Jean-Philippe

  #3  
Old December 13th 07, 10:31 AM posted to microsoft.public.outlook.program_vba
Jpgoyen
external usenet poster
 
Posts: 8
Default Writing data on a XML file on internet

Sorry, I should have precised.
I documented myself since, and understand my question must have been
puzzling, sorry.
The file is on an ftp directory. So my question was something like: can a
http server, receiving a post request sent by my outlook vba macro, write in
a file in a ftp directory? I think. I have to read more about this, should
take a while...

So the question is maybe not in the rigth place, sorry.
But I am always interested if somebody has an exemple of POST request syntax
in vba.

Thanks.

Jean-Philippe

"Eric Legault [MVP - Outlook]" wrote:

Where exactly is this file? In an FTP directory? A server side file in a
web application?

--
Eric Legault - Outlook MVP, MCDBA, MCTS (SharePoint programming, etc.)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/


"Jpgoyen" wrote:

Hello,

I am still a beginner in VBA...
I am searching a way to write/modify data in a xml file on internet from a
macro in Outlook.
I found a way, with CreateObject("MSXML2.XMLHTTP") and get method, to read
some text data in a file, or get the whole file, but didn't find any way to
write in a web file from my macro.
Has anyone already used the POST method in VBA, getting the right syntax
would help me a lot.


Thank you very much for your help or reference

Jean-Philippe

  #4  
Old December 13th 07, 08:34 PM posted to microsoft.public.outlook.program_vba
Eric Legault [MVP - Outlook]
external usenet poster
 
Posts: 830
Default Writing data on a XML file on internet

I've done this before - using the Internet Transfer Control.

Using the Internet Transfer Control:
http://msdn2.microsoft.com/en-us/lib...27(VS.60).aspx

--
Eric Legault - Outlook MVP, MCDBA, MCTS (SharePoint programming, etc.)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/


"Jpgoyen" wrote:

Sorry, I should have precised.
I documented myself since, and understand my question must have been
puzzling, sorry.
The file is on an ftp directory. So my question was something like: can a
http server, receiving a post request sent by my outlook vba macro, write in
a file in a ftp directory? I think. I have to read more about this, should
take a while...

So the question is maybe not in the rigth place, sorry.
But I am always interested if somebody has an exemple of POST request syntax
in vba.

Thanks.

Jean-Philippe

"Eric Legault [MVP - Outlook]" wrote:

Where exactly is this file? In an FTP directory? A server side file in a
web application?

--
Eric Legault - Outlook MVP, MCDBA, MCTS (SharePoint programming, etc.)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/


"Jpgoyen" wrote:

Hello,

I am still a beginner in VBA...
I am searching a way to write/modify data in a xml file on internet from a
macro in Outlook.
I found a way, with CreateObject("MSXML2.XMLHTTP") and get method, to read
some text data in a file, or get the whole file, but didn't find any way to
write in a web file from my macro.
Has anyone already used the POST method in VBA, getting the right syntax
would help me a lot.


Thank you very much for your help or reference

Jean-Philippe

 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
PRF file problem wiht personal folders data file password protecte Groupex1 Outlook - Installation 0 November 1st 07 09:01 PM
Writing small file for each received Outlook 2003 email message [email protected] Outlook and VBA 4 October 4th 07 01:35 PM
Outlook file translators stuck on a default data file or not worki Charles griffiths Outlook - Using Contacts 2 April 23rd 07 12:50 PM
PST file shows up twice in data file list Chris Bailey Outlook - General Queries 3 July 10th 06 11:57 PM
pst file option missing under new outlook data file dialog UncleBuckle Outlook - Installation 2 February 25th 06 12:49 AM


All times are GMT +1. The time now is 08:42 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.