This function copies content to the clipboard and pastes to the destination immediately. This function clears the Windows clipboard right away (so the content can't be shared, but big issue here is it also clears the clipboard). There is also another way to do copy/paste using Range.Copy function. You can also paste this content outside of Excel. ![]() Later, you can paste the content to anywhere using ActiveSheet.Paste. One is select the area first and call Selection.Copy. There are two kinds of copy you can do in Excel VBA. ![]() So, how do I "copy" data around without using Windows clipboard? Is there some concept as "local clipboard"? I don't want this content to be shared with anybody else. ![]() There is also a potential that wrong report is generated. Because the clipboard is shared, it is not only annoying because user working on the PC cannot do copy/paste anymore. Obviously, this function uses Windows clipboard. There is a big issue: We use Excel (VBA) copy function in our template to move data around. In my application, generating reports could take long time, so it normally runs in background. Hi, I'm trying to create reports using Excel templates.
0 Comments
Leave a Reply. |