I'm a newcomer to VBA. I need to use query tables to load information from
the net. I record a macro to do this and it works fine EXCEPT that it
auto-formats the times in cells into a time that excel understands. I don't
want it to do this i want it to keep it as text from the webpage.

For example, if on the web the sheet says 28:19 as in 28 minutes, 19
seconds, when i import it i want it to stay exactly as that 28:19 and i want
it to stay as text so i can manipulate it. But excel custom formats it
automatically and when i try to turn it back into text its decimal. And i
don't think those decimals represent the initial times as in 28 minutes 19
seconds.

I've tried lots of stuff but i can find no querytable property or method
that controls this (there is one for auto-formatting date, which i turned to
false and solved that problem). I turn the format of all the cells to text
prior to creating the table and it still changes the format of the cells to
custom. If i copy and paste the webpage to excel, then choose Match
Destination Formatting in the paste options this solves my problems perfectly
but i can find no way to do this with a querytable.

An example webpage:http://www.nhl.com/scores/htmlreport...8/GS021218.HTM

they are hockey statistics. Thanks.