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

I am using microsoft excel 2007, the code is not running, the macro was disabled.. How to enable the macro...?


From the excel help file

  1. Click the Microsoft Office Button o12filemenubutton_za10077102.gif, and then click Excel Options.
  2. Click Trust Center, click Trust Center Settings, and then click Macro Settings.
  3. Click the options that you want:
    • Disable all macros without notification Click this option if you don't trust macros. All macros in documents and security alerts about macros are disabled. If there are documents with unsigned macros that you do trust, you can put those documents into a trusted location. Documents in trusted locations are allowed to run without being checked by the Trust Center security system.
    • Disable all macros with notification This is the default setting. Click this option if you want macros to be disabled, but you want to get security alerts if there are macros present. This way, you can choose when to enable those macros on a case by case basis.
    • Disable all macros except digitally signed macros This setting is the same as the Disable all macros with notification option, except that if the macro is digitally signed by a trusted publisher, the macro can run if you have already trusted the publisher. If you have not trusted the publisher, you are notified. That way, you can choose to enable those signed macros or trust the publisher. All unsigned macros are disabled without notification.
    • Enable all macros (not recommended, potentially dangerous code can run) Click this option to allow all macros to run. This setting makes your computer vulnerable to potentially malicious code and is not recommended.
    • Trust access to the VBA project object model This setting is for developers and is used to deliberately lock out or allow programmatic access to the VBA object model from any Automation client. In other words, it provides a security option for code that is written to automate an Office program and programmatically manipulate the Microsoft Visual Basic for Applications (VBA) environment and object model. This is a per user and per application setting, and denies access by default. This security option makes it more difficult for unauthorized programs to build "self-replicating" code that can harm end-user systems. For any Automation client to be able to access the VBA object model programmatically, the user running the code must explicitly grant access. To turn on access, select the check box.

Jun 21, 2011 | Microsoft Office Professional 2007 Full...

1 Answer

Does office standard 2007 support VBA?


Yes it does, all versions of office 2007 supports VBA.

Oct 05, 2010 | Microsoft Office Standard for PC

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

How to dov VBA in ms office 2007


Right Click on the sheet name on the bottom left corner of the excel window and on the pop up menu, click on "View Code". It will open a box where you can perform VBA Coding.

Aug 04, 2009 | Microsoft MS OFFICE 2007 SBE MLK (NA) SW....

1 Answer

Excel vba


For complete guide please refer to this link
http://www.fontstuff.com/VBA/vbatut03.htm

Thanks and regards

Fixya is educating to educate

May 12, 2009 | Microsoft Office Professional Edition 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

3 Answers

Excel vba password recovery


You can but you will need software. Search for google for VBA password recovery tools. Search for the appropriate crack you have it all . .

Dec 30, 2007 | Microsoft Excel 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

2635 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18331 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...