ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   web query doesnt copy the essential part. (https://www.excelbanter.com/excel-programming/373325-web-query-doesnt-copy-essential-part.html)

phaidon

web query doesnt copy the essential part.
 

Hi,

I try to copy some data from a web page with the web query feature but the
outcome is that the essential part is not imported to the sheet. In excel
help it is said that "The retrieved data does not include pictures, such as
..gif images, and does not include the contents of scripts.". May this be the
problem? If yes is there any way have this done anyway?
When I copy&paste the web page myself to the sheet I get all the data that I
need so I think there should be a way to do this. Maybe a macro that opens
the web page, selects all,copies and pastes the data to the sheet? But I have
no idea about writing macros, any help on that?

Thanks,


Don Guillett

web query doesnt copy the essential part.
 
supply your url and requirements and we can take a look.

--
Don Guillett
SalesAid Software

"phaidon" wrote in message
...

Hi,

I try to copy some data from a web page with the web query feature but the
outcome is that the essential part is not imported to the sheet. In excel
help it is said that "The retrieved data does not include pictures, such
as
.gif images, and does not include the contents of scripts.". May this be
the
problem? If yes is there any way have this done anyway?
When I copy&paste the web page myself to the sheet I get all the data that
I
need so I think there should be a way to do this. Maybe a macro that opens
the web page, selects all,copies and pastes the data to the sheet? But I
have
no idea about writing macros, any help on that?

Thanks,





All times are GMT +1. The time now is 09:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com