Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Problem Between Ex 97 vs 2k
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 manually copy a web page (Ctl A and Ctl C) and then paste the contents into excel (ctl V). From there i run a macro that cleans up the the content into the raw data I need. Been working well, 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 manually 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. I've also posted here previously and rec'd no replies. Hate to think I've got everyone stumped on this one? LOL Any thoughts or help would be appreciated. Thx Dave |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Problem Between Ex 97 vs 2k
Do you have any merged cells in the worksheet that you are trying to
paste into? Does it still work using Excel 97 (i.e. no recent changes to the web site)? Pete On Jan 30, 12:52*pm, DaveM wrote: 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 manually copy a web page (Ctl A and Ctl C) and then paste the contents into excel (ctl V). *From there i run a macro that cleans up the the content into the raw data I need. *Been working well, 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 manually 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. *I've also posted here previously and rec'd no replies. * Hate to think I've got everyone stumped on this one? *LOL Any thoughts or help would be appreciated. Thx Dave |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Problem Between Ex 97 vs 2k
thanks Peter, specific to your questions
1. No merged cells. The sheet that i'm pasting in to is a blank sheet. 2. I would say yes it still works in '97. I have two pcs, one up in til last week had '97 and the other had 2000. Before this weekend i have experienced this problem if i tried running this routine on the 2000 pc though it ran fine on the '97 excel. The problem is I had to reload my OS on the older unit this weekend and I only have office 2000 to put back on it, leaving me with two pcs both having excel 2k on it. And, unfortunately i have to deal with this problem now since i no longer have 97 avaiable. Please any help would be appreciated. DAve "Pete_UK" wrote: Do you have any merged cells in the worksheet that you are trying to paste into? Does it still work using Excel 97 (i.e. no recent changes to the web site)? Pete On Jan 30, 12:52 pm, DaveM wrote: 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 manually copy a web page (Ctl A and Ctl C) and then paste the contents into excel (ctl V). From there i run a macro that cleans up the the content into the raw data I need. Been working well, 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 manually 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. I've also posted here previously and rec'd no replies. Hate to think I've got everyone stumped on this one? LOL Any thoughts or help would be appreciated. Thx Dave |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Problem Between Ex 97 vs 2k
So, there could have been a change to that website in the last few
days, but you don't have an XL97 version available to test it on now? Are you able to paste the data into Word, or Notepad, or do they also prevent you from pasting? Pete On Jan 30, 1:48*pm, DaveM wrote: thanks Peter, specific to your questions 1. No merged cells. *The sheet that i'm pasting in to is a blank sheet. 2. I would say yes it still works in '97. *I have two pcs, one up in til last week had '97 and the other had 2000. *Before this weekend i have experienced this problem if i tried running this routine on the 2000 pc though it ran fine on the '97 excel. *The problem is I had to reload my OS on the older unit this weekend and I only have office 2000 to put back on it, leaving me with two pcs both having excel 2k on it. *And, unfortunately i have to deal with this problem now since i no longer have 97 avaiable. Please any help would be appreciated. DAve "Pete_UK" wrote: Do you have any merged cells in the worksheet that you are trying to paste into? Does it still work using Excel 97 (i.e. no recent changes to the web site)? Pete On Jan 30, 12:52 pm, DaveM wrote: 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 manually copy a web page (Ctl A and Ctl C) and then paste the contents into excel (ctl V). *From there i run a macro that cleans up the the content into the raw data I need. *Been working well, 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 manually 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. *I've also posted here previously and rec'd no replies. * Hate to think I've got everyone stumped on this one? *LOL Any thoughts or help would be appreciated. Thx Dave- Hide quoted text - - Show quoted text - |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Problem Between Ex 97 vs 2k
Highly unlikely of a change to the web site as I've had this problem w/ 2000
for the past year, this is why i've used my office 97 version pc to do this work. I did try to paste into Word and it did this ok and if i copy from word to the excel 2k it places all the data in Column A. I could rewrite my macro which previouly parsed the old web data around. This would just be one more manual step to use Word and an intermediate step.... Let's see if I can get this to work. Thx Peter "Pete_UK" wrote: So, there could have been a change to that website in the last few days, but you don't have an XL97 version available to test it on now? Are you able to paste the data into Word, or Notepad, or do they also prevent you from pasting? Pete On Jan 30, 1:48 pm, DaveM wrote: thanks Peter, specific to your questions 1. No merged cells. The sheet that i'm pasting in to is a blank sheet. 2. I would say yes it still works in '97. I have two pcs, one up in til last week had '97 and the other had 2000. Before this weekend i have experienced this problem if i tried running this routine on the 2000 pc though it ran fine on the '97 excel. The problem is I had to reload my OS on the older unit this weekend and I only have office 2000 to put back on it, leaving me with two pcs both having excel 2k on it. And, unfortunately i have to deal with this problem now since i no longer have 97 avaiable. Please any help would be appreciated. DAve "Pete_UK" wrote: Do you have any merged cells in the worksheet that you are trying to paste into? Does it still work using Excel 97 (i.e. no recent changes to the web site)? Pete On Jan 30, 12:52 pm, DaveM wrote: 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 manually copy a web page (Ctl A and Ctl C) and then paste the contents into excel (ctl V). From there i run a macro that cleans up the the content into the raw data I need. Been working well, 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 manually 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. I've also posted here previously and rec'd no replies. Hate to think I've got everyone stumped on this one? LOL Any thoughts or help would be appreciated. Thx Dave- Hide quoted text - - Show quoted text - |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Problem Between Ex 97 vs 2k
You're welcome - sorry my help wasn't more tangible.
Pete On Jan 30, 2:27*pm, DaveM wrote: Highly unlikely of a change to the web site as I've had this problem w/ 2000 for the past year, this is why i've used my office 97 version pc to do this work. * I did try to paste into Word and it did this ok and if i copy from word to the excel 2k it places all the data in Column A. *I could rewrite my macro which previouly parsed the old web data around. *This would just be one more manual step to use Word and an intermediate step.... Let's see if I can get this to work. Thx Peter "Pete_UK" wrote: So, there could have been a change to that website in the last few days, but you don't have an XL97 version available to test it on now? Are you able to paste the data into Word, or Notepad, or do they also prevent you from pasting? Pete On Jan 30, 1:48 pm, DaveM wrote: thanks Peter, specific to your questions 1. No merged cells. *The sheet that i'm pasting in to is a blank sheet. 2. I would say yes it still works in '97. *I have two pcs, one up in til last week had '97 and the other had 2000. *Before this weekend i have experienced this problem if i tried running this routine on the 2000 pc though it ran fine on the '97 excel. *The problem is I had to reload my OS on the older unit this weekend and I only have office 2000 to put back on it, leaving me with two pcs both having excel 2k on it. *And, unfortunately i have to deal with this problem now since i no longer have 97 avaiable. Please any help would be appreciated. DAve "Pete_UK" wrote: Do you have any merged cells in the worksheet that you are trying to paste into? Does it still work using Excel 97 (i.e. no recent changes to the web site)? Pete On Jan 30, 12:52 pm, DaveM wrote: 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 manually copy a web page (Ctl A and Ctl C) and then paste the contents into excel (ctl V). *From there i run a macro that cleans up the the content into the raw data I need. *Been working well, 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 manually 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. *I've also posted here previously and rec'd no replies. * Hate to think I've got everyone stumped on this one? *LOL Any thoughts or help would be appreciated. Thx Dave- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paste problem | Excel Discussion (Misc queries) | |||
Paste problem | Excel Discussion (Misc queries) | |||
Problem with paste | Excel Worksheet Functions | |||
Paste Problem | Excel Discussion (Misc queries) | |||
Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) |