View Single Post
  #1  
Old 03-07-2017, 03:10 AM
JDB@Spirax JDB@Spirax is offline
Registered User
 
Join Date: Jun 2009
Location: UK
Posts: 9
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?
Reply With Quote