Hi Divaker,
If you mean the last two things copied within Excel, and you want to
identify them from VBA,
Take a look at http://www.mrexcel.com/forum/showthread.php?t=167292
Keep in mind that the commandbar containing the Office Clipboard's name
varies by Excel version. Here's how I think it goes:
In Office 2000 reference the Clipboard commandbar.
In Office XP through perhaps I guess Office 2003, reference the Task Pane
commandbar.
In perhaps Office 2007 through 2010 or 2011 (noted in Office 2010),
reference the Office Clipboard commandbar.
You might also try using the macro recorder to work with those items and see
what you get.
I have not tried this, but I saw the tip Each of the MicrosoftR Office XP
applications provides a Clipboard toolbar that you can use to store up to 12
items. In addition, you can work with the items stored by the Clipboard
toolbar programmatically through the command bar object model. The last item
copied to the Clipboard toolbar is the one stored in the Windows Clipboard.
at http://msdn.microsoft.com/en-us/library/aa189708%28v=office.10%29.aspx,
but without further elaboration.
Additional web searches might find you other/better examples.
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Divaker Pandey
Sent: Monday, March 19, 2012 4:53 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ last copied item in windows clipboard
Hi Expert,
Can anyone give me a hint to findout last and second last copied item.
Divaker
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--
To post to this group, send email to excel-macros@googlegroups.com
