Clear Office Clipboard from VBA?
in [Word VBA]
|
From: theLuggage on 24 Apr 2007 13:46 I found some code on the web to manipulate the Windows clipboard using windows API calls. Is there a way to manipulate the MS Office clipboard? Here's the scenario. I've got some code that parses through a Word document and copies all the tables and images from the Word document into an Excel Workbook. The tables all work fine, but the images are sometimes duplicated. Instead of getting image 1 and then image 2, I get two copies of image 1. Even though I clear the clipboard (using the Windows API calls) before I copy the figure, sometimes I still get the duplicate. I ran my code with the Office clipboard command bar showing and it looks like the Office clipboard doesn't get cleared at all. To show the Office clipboard, I'm just choosing View-->Toolbars-->Clipboard. Is there a way to clear the Office clipboard? Thanks in advance for the help! (Forgive the cross-post. I'm not sure where to post the question.)
From: Jay on 24 Apr 2007 14:56 Hi theLuggage - Check out this site. Chip Pearson provides crystal-clear instructions for clearing the clipboard with VBA code. http://www.cpearson.com/excel/clipboard.htm --- Jay "theLuggage" wrote: > I found some code on the web to manipulate the Windows clipboard using > windows API calls. > > Is there a way to manipulate the MS Office clipboard? > > Here's the scenario. I've got some code that parses through a Word document > and copies all the tables and images from the Word document into an Excel > Workbook. The tables all work fine, but the images are sometimes duplicated. > Instead of getting image 1 and then image 2, I get two copies of image 1. > > Even though I clear the clipboard (using the Windows API calls) before I > copy the figure, sometimes I still get the duplicate. > > I ran my code with the Office clipboard command bar showing and it looks > like the Office clipboard doesn't get cleared at all. To show the Office > clipboard, I'm just choosing View-->Toolbars-->Clipboard. > > Is there a way to clear the Office clipboard? > > Thanks in advance for the help! > > (Forgive the cross-post. I'm not sure where to post the question.)
From: Karl E. Peterson on 24 Apr 2007 15:11 That's the Windows clipboard, not the Office one, no? I'm not aware of methods to access the Office clipboard from VBA, but would love to learn that isn't because it's impossible! -- ..NET: It's About Trust! http://vfred.mvps.org Jay <Jay(a)discussions.microsoft.com> wrote: > Hi theLuggage - > > Check out this site. Chip Pearson provides crystal-clear instructions for > clearing the clipboard with VBA code. > > http://www.cpearson.com/excel/clipboard.htm > > --- > Jay > > "theLuggage" wrote: > >> I found some code on the web to manipulate the Windows clipboard using >> windows API calls. >> >> Is there a way to manipulate the MS Office clipboard? >> >> Here's the scenario. I've got some code that parses through a Word document >> and copies all the tables and images from the Word document into an Excel >> Workbook. The tables all work fine, but the images are sometimes duplicated. >> Instead of getting image 1 and then image 2, I get two copies of image 1. >> >> Even though I clear the clipboard (using the Windows API calls) before I >> copy the figure, sometimes I still get the duplicate. >> >> I ran my code with the Office clipboard command bar showing and it looks >> like the Office clipboard doesn't get cleared at all. To show the Office >> clipboard, I'm just choosing View-->Toolbars-->Clipboard. >> >> Is there a way to clear the Office clipboard? >> >> Thanks in advance for the help! >> >> (Forgive the cross-post. I'm not sure where to post the question.)
From: JLGWhiz on 24 Apr 2007 15:38 There is more than one clipboard??? "theLuggage" wrote: > I found some code on the web to manipulate the Windows clipboard using > windows API calls. > > Is there a way to manipulate the MS Office clipboard? > > Here's the scenario. I've got some code that parses through a Word document > and copies all the tables and images from the Word document into an Excel > Workbook. The tables all work fine, but the images are sometimes duplicated. > Instead of getting image 1 and then image 2, I get two copies of image 1. > > Even though I clear the clipboard (using the Windows API calls) before I > copy the figure, sometimes I still get the duplicate. > > I ran my code with the Office clipboard command bar showing and it looks > like the Office clipboard doesn't get cleared at all. To show the Office > clipboard, I'm just choosing View-->Toolbars-->Clipboard. > > Is there a way to clear the Office clipboard? > > Thanks in advance for the help! > > (Forgive the cross-post. I'm not sure where to post the question.)
From: JLGWhiz on 24 Apr 2007 15:54 You can access the Office Clipboard Edit>OfficeClipboard in Excel. It should show what is on it, if anything, from whatever source. You can then edit it one item at a time or all at once. See Excel help on Clipboard. "theLuggage" wrote: > I found some code on the web to manipulate the Windows clipboard using > windows API calls. > > Is there a way to manipulate the MS Office clipboard? > > Here's the scenario. I've got some code that parses through a Word document > and copies all the tables and images from the Word document into an Excel > Workbook. The tables all work fine, but the images are sometimes duplicated. > Instead of getting image 1 and then image 2, I get two copies of image 1. > > Even though I clear the clipboard (using the Windows API calls) before I > copy the figure, sometimes I still get the duplicate. > > I ran my code with the Office clipboard command bar showing and it looks > like the Office clipboard doesn't get cleared at all. To show the Office > clipboard, I'm just choosing View-->Toolbars-->Clipboard. > > Is there a way to clear the Office clipboard? > > Thanks in advance for the help! > > (Forgive the cross-post. I'm not sure where to post the question.)
|
Next
|
Last
Pages: 1 2 3 4 5 Prev: Multiple Users Not Saving Data to a Form Template Next: Tab problem |