Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / April 2007

Tip: Looking for answers? Try searching our database.

Save a copy of an xml on a server using VBA

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Mikael.Landau@gmail.com - 13 Apr 2007 19:05 GMT
This is a tough one...

I have a highly suseptible file in XML on a server with an http
address that I can access through a slew of propriatory applications.
I would like to create a copy of the file on my local drive using VBA.
THe problem is that:

1) I can't use saveas because if I do the active document becomes the
new copy and I can't programaticly reopen the old one because the
http: address will only open throught the prop app.

2) it's XML and it goes crazy (looses the XML coding in the
background) when i select all and paste it into a new temp file.

Thanks for your help...
Cindy M. - 14 Apr 2007 11:15 GMT
> I have a highly suseptible file in XML on a server with an http
> address that I can access through a slew of propriatory applications.
[quoted text clipped - 7 lines]
> 2) it's XML and it goes crazy (looses the XML coding in the
> background) when i select all and paste it into a new temp file.

XML is really just a plain text file. So you should be able to use the
standard VB Open, Read, Write and Print commands with it, just as for
any *.txt file.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question
or reply in the newsgroup and not by e-mail :-)
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.