noobieautolearn Posted April 4, 2016 Share Posted April 4, 2016 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. Link to comment Share on other sites More sharing options...
alien4u Posted April 4, 2016 Share Posted April 4, 2016 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. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now