Question about Microsoft Office Standard for PC
Thanks Stoneb for taking an interest in my problem with the Visual Basic coding for the Microsoft Office Clipboard. You mentioned perhaps using sendkeys which mimmick an actual key press. But I don't believe this applies because what I would require, if I were to approach the problem in a similar fashion to what you had in mind is a way to mimmick a mouse click on either of two buttons. The first coding would mimmick clicking on the Office Clipboard panel button: "paste all"; whereas, the second coding would mimmick clicking the Office Clipboard panel button: "clear all".
Would you agree that since the Office Clipboard panel can be anchored on all 4 sides of the screen that I need a way to first identify each button whereever it is onscreen, and, next, a way to mimmick a left mouse click?
The possible second solution you give is employing the possible routines given in the library of Win32 API coding. I have done a preliminary search through this library by category and found some coding on the clipboard which may only apply to the regular System Clipboard which can hold only one item at a time, as opposed to the Microsoft Office Clipboard which can hold up to 24 items at a time. I have tried transposing some of this Win32 API code into the Visual Basic editor which doesn't seem to like the syntax as the coding text turns red. Is this because the Win32 API is C++ code? Incidentally, if I let Excel record my macro automatically, when I look at the resulting code in the editor aferward, all I see is identical "paste" codes, one for each item on the clipboard. But when I run this recorded macro it justs uses the most current item copied to the clipboard, which is the same as the regular System Clipboard; So this same item gets pasted into the Excel spreadsheet for as many times as the "paste" code occurs in the macro. This may suggest that when Excel is automatically recording the macro, it has a means of incrementing to the next memory location where the next Office Clipboard item is stored. Perhaps this is done by some low level language call which is never indicated in the Visual Basic editor because it may not be recognized by the VB editor as proper syntax format.
Perhaps you will yet help me to solve this nagging problem. Would you know a way to identify the "paste all" and "clear all" buttons onscreen followed by a simulated click? Or perhaps you might be more specific about some Win32 API code which exists to do the job. If so, what is the language it is written in and how can I insert it in the Visual Basic Editor so that it will recognize the syntax?
For your benefit, I am repeating the question further down that I posed on "FIXYA" and which you so kindly responded to. You may reply to me at: firstname.lastname@example.org You may yet be the guru wiz who will help me out of my dilemma. For that I would be sooo appreciative and publish your name far and wide. lol.
Here is my original question Stoneb:
The Microsoft Office Clipboard, as opposed to the regular system Clipboard, has the ability to store up to 24 separate items at a time. When turned on, the Office Clipboard is a vertical panel displaying a representation of each of the items contained on it. It has two buttons: One to paste all of its contents at once; the other, to clear all of its contents. I am writing a Visual Basic macro program for an Excel Spreadsheet and I am searching for a command, function, or routine which will paste all of the Office Clipboard items into my spreadsheet at once. When I let Excel automatically record the macro for me and I press the "Paste All" button in the Office Clipboard panel, I can't get the answer I am looking for; when I stop the macro recording process and check the Visual Basic editor, all I see is the "paste" command issued there multiple times, once for each Office Clipboard item. There is no single generic command, function, or routine visible. There must be some hidden code behind the "Paste All" button press event. Can you be of assistance to me? My email address is email@example.com Thanks.
Very interesting problem, i can't seem to find any code that covers this.
Here's a quick (dirty) solution that should work (however if users of your macro are using different resolutions you will want to check for that and modify accordingly)
Basically you tell the mouse the exact position on the screen to move, then tell it to click. A bunch of example on how to do this are here:
Posted on Jul 22, 2008
a 6ya Technician can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repair professionals here in the US.
click here to Talk to a Technician (only for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Mar 17, 2011 | Microsoft Office Professional 2007 Full...
Sep 04, 2010 | Microsoft Office 2003 Basic Edition...
May 22, 2010 | HP PSC 2210 All-In-One InkJet Printer
Apr 28, 2010 | Microsoft Visual Studio 2008 Professional...
Mar 20, 2010 | Microsoft Windows XP Professional
May 08, 2009 | Microsoft Visual Basic .NET Standard 2003...
Jul 12, 2008 | Microsoft Office Standard for PC
Apr 03, 2008 | Microsoft Office Standard for PC
3,079 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: