CoCreate User Forum

CoCreate User Forum (https://www.cocreateusers.org/forum/index.php)
-   Annotation (https://www.cocreateusers.org/forum/forumdisplay.php?f=6)
-   -   OLE Spreadsheet Issue (https://www.cocreateusers.org/forum/showthread.php?t=8278)

JDB@Spirax 03-07-2017 03:10 AM

OLE Spreadsheet Issue
 
Hi.

If you are not already aware, there is an issue embedding spreadsheets in to Annotation. Only a portion of the spreadsheet is captured and displayed in the drawing. This has been reported to PTC and they have indicated that it is a problem in Excel.

I have developed a 'work around' by using a hidden OLE spreadsheet and adding a VBA routine to the spreadsheet. The routine allows the user to define the area of the spreadsheet to be captured and then add the defined area to Annotation as a picture .

The only issue I have is trying to set the QUALITY_FACTOR value of the picture using a DDEExecute nChannelNumber VBA command.

Does anyone know if this can be done?


All times are GMT -8. The time now is 11:14 PM.

Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.