![]() |
Managing Cut/Copy & Paste During Program Run
I have a couple programs that make use of copy and paste during code
run to move around entire rows or columns. The problem I run into is that the programs might run for an extended period of time so, the user has time to work on other things during that period. However, while the code is running, the user loses the ability to copy and paste because the program is hitting the clipboard buffer. My question: Is there a way to do a cut/copy&paste where VBE use a clipboard buffer seperate from the system-wide clipboard buffer the user would be utilizing? Any work around I've been able to dream up so far would be horribly slow and cumbersome. Thanks, Cory |
Managing Cut/Copy & Paste During Program Run
Cory Layman brought next idea :
I have a couple programs that make use of copy and paste during code run to move around entire rows or columns. The problem I run into is that the programs might run for an extended period of time so, the user has time to work on other things during that period. However, while the code is running, the user loses the ability to copy and paste because the program is hitting the clipboard buffer. My question: Is there a way to do a cut/copy&paste where VBE use a clipboard buffer seperate from the system-wide clipboard buffer the user would be utilizing? Any work around I've been able to dream up so far would be horribly slow and cumbersome. Thanks, Cory When your code is done with each cut/copy/paste, try clearing the clipboard so it's empty... Application.CutCopyMode = False -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
All times are GMT +1. The time now is 03:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com