Sign in to follow this  
Followers 0
noobieautolearn

Copy and Paste issues

2 posts in this topic

I have a script that copies and pastes things from excel and I've noticed that sometimes it just doesn't get everything it should.  Does anyone else ever have this issue?  Should you clear the clipboard every so often?  Should you slow down how fast it is copying and pasting is there something else you can do it improve the reliability of it grabbing things off the clipboard and creating variables from the clipboard?  To be clear, sometimes when I run the script it gets everything fine but other times it may miss one or 2 things, sometimes more.

Share this post


Link to post
Share on other sites



Check Excel UDF there should be Obj option to read data and write data inside excel without the need of Copy and Paste, ClipGet and ClipPut what you probably use have some limitations, 64kb buffer and also no Unicode support(no completely sure). Anyways the best approach is to use UDF that work with Excel Objects documented on Microsoft MSDN.


_Excel_RangeCopyPaste
_Excel_RangeRead
_Excel_RangeInsert

Look at _Excel* on Help File.

Kind Regards
Alien.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0