Microsoft Office Standard for PC Logo
Posted on Jul 12, 2008
Answered by a Fixya Expert

Trustworthy Expert Solutions

At Fixya.com, our trusted experts are meticulously vetted and possess extensive experience in their respective fields. Backed by a community of knowledgeable professionals, our platform ensures that the solutions provided are thoroughly researched and validated.

View Our Top Experts

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

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.

2 Answers

Anonymous

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.

Scholar:

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

  • Expert 175 Answers
  • Posted on Nov 30, 2011
Anonymous
Expert
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.

Scholar:

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

Joined: Jun 09, 2011
Answers
175
Questions
3
Helped
219448
Points
182

Anypasskey EXCEL Password Recovery is Professional utility works on Password recovery, it can recover all versions of EXCEL files quickly and efficiently, and its previous versions and easily get EXCEL password reset. It deserves trying.

Anonymous

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
  • Posted on Jul 20, 2008
Anonymous
Expert
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.

Joined: Jan 03, 2008
Answers
167
Questions
4
Helped
75082
Points
374

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

Ad

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

368 views

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3269 Answers

Grand Canyon Tech
Grand Canyon Tech

Level 3 Expert

3869 Answers

Brad Brown

Level 3 Expert

19190 Answers

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

Answer questions

Manuals & User Guides

Loading...