Hello to all, although just signing up as a member to the forum today,
I’ve actually been visiting for years and have picked up lots of
valuable information along the way.
So, much thanks for all the help that that you’ve given me before and
thanks in advance for any advice you can offer on my current issue.

The issue occurs while trying to include the HTML data in a Query
import from the stats page for our cancer research team with World
Community Grid. The numerical data will import or refresh with no
problems, but if you try to include the ‘Full HTML formatting’ under
the Options menu it will only give you the hyperlinks that are included
in the data names, but will not give you the color shading that varies
from one line to the next in the lines of data… and those shadings are
what we are trying for.
So the question is, are we missing something in our Query setup, or is
it just that the page we are importing from will not produce the same
‘look’ in an HTML data import as what you see on their page?

Here is the page we are going to for the data Query:
'WCG Team Info' (http://tinyurl.com/fox3g)

And, at the following link you can see what a finished chart looks like
that one of our members is currently posting; we are trying to end up
with something similar to this when doing our refresh/import data
without having to manually add in the formatting.
'BitBenderForums Cancer Research'
(http://www.bitbenderforums.com/forum...364#post409364)

Thanks... Ken


--
ken.kimbrell
------------------------------------------------------------------------
ken.kimbrell's Profile: http://www.excelforum.com/member.php...o&userid=34224
View this thread: http://www.excelforum.com/showthread...hreadid=539816

AFAIK you cannot control the color shadings.

--
Don Guillett
SalesAid Software

"ken.kimbrell"
wrote in message
news:ken.kimbrell.27hmdy_1147089601.4393@excelforu m-nospam.com...

Hello to all, although just signing up as a member to the forum today,
I’ve actually been visiting for years and have picked up lots of
valuable information along the way.
So, much thanks for all the help that that you’ve given me before and
thanks in advance for any advice you can offer on my current issue.

The issue occurs while trying to include the HTML data in a Query
import from the stats page for our cancer research team with World
Community Grid. The numerical data will import or refresh with no
problems, but if you try to include the ‘Full HTML formatting’ under
the Options menu it will only give you the hyperlinks that are included
in the data names, but will not give you the color shading that varies
from one line to the next in the lines of data… and those shadings are
what we are trying for.
So the question is, are we missing something in our Query setup, or is
it just that the page we are importing from will not produce the same
‘look’ in an HTML data import as what you see on their page?

Here is the page we are going to for the data Query:
'WCG Team Info' (http://tinyurl.com/fox3g)

And, at the following link you can see what a finished chart looks like
that one of our members is currently posting; we are trying to end up
with something similar to this when doing our refresh/import data
without having to manually add in the formatting.
'BitBenderForums Cancer Research'
(http://www.bitbenderforums.com/forum...364#post409364)

Thanks... Ken


--
ken.kimbrell
------------------------------------------------------------------------
ken.kimbrell's Profile:
http://www.excelforum.com/member.php...o&userid=34224
View this thread: http://www.excelforum.com/showthread...hreadid=539816

Thanks Don
I was afraid that might be the answer, but was hopeful that there might
be a way to keep more of the formatting than just the hyperlinks (that
we don't need) when doing the data import.

Thanks for the help... Ken


--
ken.kimbrell
------------------------------------------------------------------------
ken.kimbrell's Profile: http://www.excelforum.com/member.php...o&userid=34224
View this thread: http://www.excelforum.com/showthread...hreadid=539816