CoCreate User Forum  

Go Back   CoCreate User Forum > Applications > Annotation

Thread Tools Search this Thread Rating: Thread Rating: 3 votes, 1.00 average. Display Modes
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


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

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

All times are GMT -8. The time now is 08:31 AM.

Hosted by SureServer    Forums   Modeling FAQ   Macro Site   Vendor/Contractors   Software Resellers   CoCreate   Gallery   Home   Board Members   Regional User Groups  By-Laws  

Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
You Rated this Thread: