D
DaveM
I have both excel 97 and 2000 running on sperate pcs.
I have been running a routin for a couple years on the 97 version
where I select and copy a web page (Ctl A and Ctl C) and then paste the
contents
into another excel workbook (ctl V). From there i run a macro that cleans up
the the content into the raw data I need by removing the formats, deleting
some row/columns, etc. It has been working well for years, no issues.
I'm now trying to do the same routine on my other box w/ Excel 2000 on
windows XP. When i try to paste the web page data into Excel I
recieve a message "Microsoft Excel cannot paste the data".
I've looked at MS Knowledge base for this type of error with no
results or help.
Any thoughts or help would be appreciated.
Thx
Dave
I have been running a routin for a couple years on the 97 version
where I select and copy a web page (Ctl A and Ctl C) and then paste the
contents
into another excel workbook (ctl V). From there i run a macro that cleans up
the the content into the raw data I need by removing the formats, deleting
some row/columns, etc. It has been working well for years, no issues.
I'm now trying to do the same routine on my other box w/ Excel 2000 on
windows XP. When i try to paste the web page data into Excel I
recieve a message "Microsoft Excel cannot paste the data".
I've looked at MS Knowledge base for this type of error with no
results or help.
Any thoughts or help would be appreciated.
Thx
Dave