LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Excel Clipboard Problems

Office 97 sr2

I have an application that copies excel ranges (that often contain charts)
and pastes them inline into word using the 'Picture' format
(wdPasteMetafilePicture). This process generates a 4605 error "This method
or property is not available because the Clipboard is empty or not valid."
with some frequency.

* Both excel and word are invisible when the process runs
* Both applications have had alerts disabled
* I am using the 'OpenClipboard' API to lock the clipboard immediately after
copying from excel
* I am using the 'CloseClipboard' API to unlock it just before pasting into
word
* I am setting CutCopyMode = False after completing the paste operation in
word
* I am clearing the clipboard after the paste operation using the clear
method of VB's clipboard object
* I am losing my mind

While debugging I have noticed that other applications (such as wordpad)
have the paste option ghosted, however I can paste the data back into excel.
Therefore it seems that excel has it's own clipboard and that this clipboard
does not always communicate well with the windows clipboard. It also seems
to me that this is some sort of resource issue because it is not consistent
and seems to happen more when the machine (nt4 terminal-server) is under
load.

Does anybody know why this happens? What can I do to fix it? Would I have
better reliability if I were use 'CopyPicture' insetad of the standard copy
method?

Thanks very much

-Brian




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Where does Ms XL store the clipboard ? or where does MS Windowsstore clipboard ? Subu Setting up and Configuration of Excel 1 May 18th 09 06:56 AM
Where does Ms XL store the clipboard ? or where does MS Windowsstore clipboard ? Subu Setting up and Configuration of Excel 0 May 5th 09 01:20 PM
Clipboard empty but still get waring that clipboard is full Steve Excel Discussion (Misc queries) 0 June 17th 08 09:05 PM
Clipboard in Excel Gary Moore Excel Discussion (Misc queries) 0 June 3rd 06 03:43 AM
Excel Clipboard... ldiaz Excel Discussion (Misc queries) 1 October 1st 05 09:27 PM


All times are GMT +1. The time now is 02:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"