Jump to content
Macro Express Forums

Info On Copying Large Amounts Of Data


johnboy691

Recommended Posts

I am trying to capture by using Ctrl c (with control down and up commands), also tried clipboard copy, of say 1,000 to 1,500 lines and four columns of data from one Excel worksheet to another worksheet. I can't seem to get more than 150 to 200 lines to print in the new worksheet without getting garbage after that; and doing that garbage on one line.

 

I have tried assigning the copy to a variable and printing using the variable, (that takes forever, but still only goes so far) I've tried copying and pasting using the clipboard. Nothing! Anyone have any ideas.

 

Thanks, John

Link to comment
Share on other sites

There must be something wrong. I routinely copy huge amounts of Excel data and don’t usually have a problem.

 

Hint: If you want to highlight ranges in Excel use the F5 command. Works brilliant in ME.

 

When you copy tables of data from an Office app it will be in the format of a tab separated value file with tabs and CRLF on the ends of lines. If I were you I would copy the clipboard to a variable and write that to a file. Then open that file with a hex editor. When you get to the point where it’s going wrong see what’s different.

 

Otherwise you would need to post an example with instructions so one of use could see where you are going wrong.

Link to comment
Share on other sites

Cory:

Thanks for your reply. I went back and went line by line and really couldn't find anything wrong. So because you said you copied large amounts of info all the time I figured I had something wrong. Anyway...after proofing and proofing what I finally noticed was that once I copied the data using the clipboard, the macro sent me to the next worksheet and before it would paste it would do a text type of variable %T1%, arrow right and then paste. The only thing between the copy and paste commands was the printing of that variable. I took the command out to do the T1 text type and BINGO! my data pasted. Why I don't understand why, evidently the printing of the vairable uses clipboard?, but I get my data to paste now; and I do my Text type for the T1 after the pasting. Works like a charm.

Thanks,

John

Link to comment
Share on other sites

Sorry, bad choice of words. I had the variable %T1% in a text type command. %T1% was a value completely unrelated to the data being copied and pasted.

 

The macro would copy from one worksheet, go to the other worksheet, then text type the value of %T1% into say cell A1, arrow right and then do the clipboard paste of the data from the previous worksheet. Which didn't work.

 

When I took out that Text Type command of putting in the value of %T1% into cell A1, and went directly to clipboard paste, my data pasted. :rolleyes:

 

I now have the command to print the %T1% value do it's thing after doing the paste. Again, Thanks.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...