Thread
:
web query
View Single Post
#
1
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
web query
try
' .WebFormatting = xlWebFormattingNone
--
Don Guillett
SalesAid Software
"RonMosley" wrote in message
...
I have a web query based excell spreadsheet. One column contains page
numbers that link to the information I need. Pages such as 7-1 are imported
as July 1 instead of text. A macro can take care of the display with
"mm-dd", but I can not apply this to the entire column because then page 10
will display as Jan 10. If I format the entire column as text, then Jun 1
will display as 38139. There are over a hundred pages to selectively format.
I had a macro that did just that, then the web page changed and the
formating no is off.
Any way to force the import to be text only?
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]