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?
|