Can any one tell me how to assign a worksheet as the xml source?

[EDUCATED MONKEY]

The set up is office 2007 windows XP professional IE8<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
At present I have an HTTP string which I dispatch via InternetExplorer.application the data is then sent back as xml and is pasted in the column A
This bit work fine. <o></o>
The part I am having problems with is using the from xml data import option,on the from other sources tab, if I manualy save the xml file to drive C then locate it as part of the import everything works perfectly<o></o>
So what I need to do is make the worksheet the source then it will accomplish the task

Sub XMLCONTROL()

'
' XMLCONTROL Macro
'
' Keyboard Shortcut: Ctrl+Shift+Z
'
Dim Q As String
Dim aurl As String
Dim EXP
 
 
                                 aurl = Worksheets("CONTROL").Range("C2").Value ' pass HTTP string in
 
 
                      Set EXP = CreateObject("InternetExplorer.application")
                                 EXP.Visible = True
                                      EXP.Navigate (aurl)
 
                  Application.Wait (Now + TimeSerial(0, 0, 5))
                                  SendKeys "^a"
                                  SendKeys "^c"
                 Application.Wait (Now + TimeSerial(0, 0, 5))
 
                         Worksheets("TEST XML").Activate
                         Worksheets("TEST XML").Range("A1").Select
   ActiveSheet.PasteSpecial Format:="Text", LINK:=False, DisplayAsIcon:= _
       False
 
Call CloseIE
 
End Sub 

 

[AlphaFrog]

Use the XMLHttp object.

Do a web search for something like Excel VBA XMLHttp object for several additional examples of it's use.

 

[EDUCATED MONKEY]

Use the XMLHttp object.

Do a web search for something like Excel VBA XMLHttp object for several additional examples of it's use.

Thanks will do

pete

 

[EDUCATED MONKEY]

Thanks will do

pete

Hello followed your advice, it seems there are a lot of terms that I have not come across as of yet, do you know of an example that I could look at?<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
As I have got very confused with it all, <o></o>
<o> </o>
What I need do is send a HTTP string to a web server and deal with the retuned xml<o></o>
<o> </o>
<o> </o>
Another idea I had was to get vba to save the web page, using the save as and taking part of the returned heading of that page as the file name of course this would need to save it as an xml file
Looking at the problem in a different way when the page is open on my desk top pc I can click file then save as the dialog box then requires a name and a location to save the file? Then get vba to mimic my actions to accomplish the task.

 

[AlphaFrog]

I don't have any specific examples other that what you could find with a web search.