ExcelBanter
(
https://www.excelbanter.com/
)
-
Excel Programming
(
https://www.excelbanter.com/excel-programming/
)
- -
web query
(
https://www.excelbanter.com/excel-programming/287360-re-web-query.html
)
Don Guillett[_4_]
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?
All times are GMT +1. The time now is
01:03 PM
.
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com