EDUCATED MONKEY
Board Regular
- Joined
- Jul 17, 2011
- Messages
- 218
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
ffice
ffice" /><o
></o
>
The set up is office 2007 xp pro ie 8<o
></o
>
I am use a sub that was worked with ordinary text, but for some reason it will not past the returned xml.<o
></o
>
<o
> </o
>
I can get the xml copy and past in the worksheet column no problem <o
></o
>
I recorded a macro and the result was this code <o
></o
>
Columns("A:A").Select<o
></o
>
ActiveSheet.PasteSpecial Format:="Text", Link:=False, DisplayAsIcon:= _<o
></o
>
False<o
></o
>
Which is not that different to the one I have used in the past with success so what I am doing wrong?<o
></o
>
Worksheets("INCOMMING_DATA").Range("A1").Select<o
></o
>
ActiveSheet.PasteSpecial Format:="Text", Link:=False, DisplayAsIcon:= _<o
></o
>
False<o
></o
>
Nether version works in the case, however at one point I though I seen the data in column A then it disappeared <o
></o
>
I have investigated the url is correct as I can see the data arrive in the browser, and I am able to copy and past that with out any problem <o
></o
>
![Eek! :o :o](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f631.png)
![Eek! :o :o](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f631.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
The set up is office 2007 xp pro ie 8<o
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
I am use a sub that was worked with ordinary text, but for some reason it will not past the returned xml.<o
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
<o
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
I can get the xml copy and past in the worksheet column no problem <o
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
I recorded a macro and the result was this code <o
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
Columns("A:A").Select<o
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
ActiveSheet.PasteSpecial Format:="Text", Link:=False, DisplayAsIcon:= _<o
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
False<o
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
Which is not that different to the one I have used in the past with success so what I am doing wrong?<o
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
Worksheets("INCOMMING_DATA").Range("A1").Select<o
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
ActiveSheet.PasteSpecial Format:="Text", Link:=False, DisplayAsIcon:= _<o
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
False<o
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
Nether version works in the case, however at one point I though I seen the data in column A then it disappeared <o
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
I have investigated the url is correct as I can see the data arrive in the browser, and I am able to copy and past that with out any problem <o
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
![Stick out tongue :p :p](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png)
Rich (BB code):
Sub RetriveAuthor()
'
' RetriveAuthor Macro
' Macro recorded 09/08/2011 by Peter Hayward
'
' Keyboard Shortcut: Ctrl+a Columns("A:A").Select
Dim Q As String
Dim aurl As String
Dim EXP
Sheets("CONTROL").Select
Q = Worksheets("CONTROL").Range("C2").Value ' pass AUTHOR in
aurl = "http://api.alibris.com/v1/public/search?wquery=" & Q & "&apikey="
Set EXP = CreateObject("InternetExplorer.application")
EXP.Visible = True
EXP.Navigate (aurl)
Application.Wait (Now + TimeSerial(0, 0, 4))
SendKeys "^a"
SendKeys "^c"
Application.Wait (Now + TimeSerial(0, 0, 1))
Worksheets("INCOMMING_DATA").Select
Worksheets("INCOMMING_DATA").Range("A1").Select
ActiveSheet.PasteSpecial Format:="Text", Link:=False, DisplayAsIcon:= _
False
End Sub