Web query problem

[Scoop]

Using 2007, I've tried to set up a web query to the table of products
in the following site. Excel doesn't seem to see the table. Any ideas
why?

http://www.niap-ccevs.org/cc-scheme/vpl/

 

[Don Guillett]

The trick is to bring in the entire page. Then you will need a macro to get
what is desired. This is the sort of thing I do often for my clients.

..Connection = "URL;http://www.niap-ccevs.org/cc-scheme/vpl"
.WebSelectionType = xlEntirePage

 

[Scoop]

Thanks, Don. I'll give it a try.