I tend to record all my actions in a macro and then hack around t
create what i really need.

This project is to download data from a web site using the web quer
and then to create a pivot table of the data.

Problem 1 occurred when trying to change text from the form 01.02.200
to date format. I assumed this would be a recognisable date format bu
i couldnt seem to make Excel understand it until i replaced the '.
with '/'. So i used a replace all for '.' with '/' no problem. Howeve
if i recorded this as a macro and replayed it then it made some errors
occasionally some date would be reversed and appear as 02/01/2006.

Anyone know why it reversed the month and day?

ill post problem 2 another time
Pau

--
pamalpas
-----------------------------------------------------------------------
pamalpass's Profile: http://www.excelforum.com/member.php...fo&userid=3195
View this thread: http://www.excelforum.com/showthread.php?threadid=51672