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: 1
Default CopyPicture is giving problem

Hi,

I'm using VB to copy the excel content and paste it in powerpoint.
Due to some reason, i'm locking the clipboard to avoid user copy paste
while doing this task
I'm using the below steps to lock the clipboard and release.

step 1 - Openclipboard
step 2 - EmptyClipboard
step 3 - use excel range.copy (or copypicture) to copy the content to
clipboard
step 4 - paste the content in the powerpoint
step 5 - CloseClipboard


Following are the issues im facing while doing this task:

1. I'm not able to use range.CopyPicture method after locking the
clipboard (Error is "Cannot Empty the clipbard")
(Please note that excel is present as the COM server (server object is
created using the create object method))


Is there a alternate way to achieve the above

Your suggestions are most welcome

Thanks & Regards,
Ahmed.
 
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
Range CopyPicture() GS80 Charts and Charting in Excel 8 January 30th 08 03:41 PM
Macro creating chart gallery giving problem Pranav Vaidya Charts and Charting in Excel 0 August 8th 07 12:02 PM
Control size of chart - CopyPicture Fredrik E. Nilsen Charts and Charting in Excel 0 April 20th 07 05:51 PM
CopyPicture ????? Paul Smith Charts and Charting in Excel 3 February 15th 05 10:49 PM
CopyPicture Remi Excel Programming 7 November 12th 03 05:25 PM


All times are GMT +1. The time now is 03:55 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"