Question about Microsoft Office Standard for PC

1 Answer

Microsoft Office Clipboard operations VBA coding for "paste all" and "clear all"

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: prince_howie_knighted@yahoo.ca 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 prince_howie_knighted@yahoo.ca Thanks.

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that gotĀ 5 achievements.

    Novelist:

    An expert who has written 50 answers of more than 400 characters.

    Governor:

    An expert whose answer gotĀ voted for 20 times.

  • Expert
  • 167 Answers

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:
http://www.vb-helper.com/index_tips_and_tricks.html#mouse

Posted on Jul 22, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert 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 repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

System error &H80040111 (-2147221231)


Hi,
Try installing your .NET frameworks and other Windows related runtimes.Also try re-installing the complete Microsoft Office package

Jan 28, 2012 | Microsoft Office Computers & Internet

1 Answer

How to use paste as hyperlink in edit menu in office 2003


To paste as hyperlink in edit menu in MsOffice 2003>Customize Toolbars Descriptions:

Paste as Hyperlink. Inserts the contents of the Clipboard as a hyperlink at the insertion point, replacing any selection. This command is available only after having cut or copied the contents of a cell or data from another program. So if you copy something from Word to the clipboard, paste as hyperlink should be available.

All the Best!

Sep 04, 2010 | Microsoft Office 2003 Basic Edition...

1 Answer

I printed a picture I scanned the other day, today I am trying to print something in Microsoft word but it keeps printing the scanned picture. How do I clear that out and print from Microsoft?


The problem might be with the clipboard but this is really interesting problem. First try to delete the picture from your file that you are priting. If that is not the case try this:

From the upper toolbar pick Edit - Office Clipboard and then hit "Clear all" button.

I hope it helps

If not, contact me via my website

mike
http://www.mswordhelp.com
how to microsoft word; philosophy, tutorials, tips and tricks

May 22, 2010 | HP PSC 2210 All-In-One InkJet Printer

1 Answer

How to convert vba macros to visual studio?


  1. Clean your code. There are built in Application specific functions which don't work in VB Studio. Some will require you pre-load the application first, others just don't work at all.
  2. Save the VBA module as a BAS file. This is just a text file with the module code in it.
  3. Export your forms to file.
  4. Open Visual Studio
  5. Import your forms and modules
  6. Clean it up.
  7. Compile it

Apr 28, 2010 | Microsoft Visual Studio 2008 Professional...

1 Answer

Cut and paste, in word, has stopped working?


The clipboard may be corrupted, or disabled. When you copy something it copys it to the Clipboard so that you can paste it later. check to see that the Clipboard service is enabled. go to START , RUN, Type Services.msc. Look for clipboard and make sure its automatic, and enabled, and started. If it is. then you may need to try something else.

Mar 20, 2010 | Microsoft Windows XP Professional

1 Answer

How to make cut copy and paste command in vc#.net


This will copy the contents of a TextBox to the clipboard:
Clipboard.SetText(txtData.Text);

This will paste the contents of the Clipboard to a TextBox:
txtData.Text = Clipboard.GetText();

May 08, 2009 | Microsoft Visual Basic .NET Standard 2003...

1 Answer

VBA not working in all Office products


There is setting for VBA in office 2007.
Go to Excel options-->Trust center--> trust center setting and configure the required settings

Jan 04, 2009 | Microsoft Office Standard for PC

2 Answers

Visual Basic code to paste all items from Office Clipboard into Excel spreadsheet


This may sound like a **** solution, but sometimes SENDKEYS can come in handy for situations like this instead of messing with with more advanced solutions. Also you can try to use win32API calls

Jul 12, 2008 | Microsoft Office Standard for PC

1 Answer

Office 2007 Standard - VBA not working


There is no indication that VBA should not work in all versions of Excel. There is a new file extension (xlsm), which is used to activate macros and allow usage. If you have, perhaps, opened and saved with incorrect extension (new is xlsx), VBA may be unavailable. Try to resave it with the changed extension. It seems likely that this is the issue (reference http://office.microsoft.com/en-us/excel/HP100141031033.aspx?pid=CH100648071033). Also, if you make sure your Save As option is set at xlsm, this should help to prevent problems. VBA should not be an issue in any version of Excel and custom functions ARE available (see http://office.microsoft.com/en-us/excel/HA102189961033.aspx?pid=CH100645021033). It should be as simple as changing the extension, and I would suggest changing the default save as option. If this helps, please rate "FixYa"! Thanks!

Apr 03, 2008 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft Office Standard for PC Logo

3,071 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2644 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18381 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...