Inserting point field into an embedded xls table in a custom form (PCD)

Welcome to the Calyx Software Message Boards where you can share ideas and solutions with other Calyx users! Calyx personnel including Tech Support, Development, QA, and Business Planning often visit these message boards unofficially to better understand our customers' needs. To submit your suggestions Click Here.

This discussion forum is a service provided by Calyx Software. Calyx Software does not endorse any particular point of view expressed in this forum or any information provided in it. The use of the information provided by other users in this message board is at your own risk.

Calyx Software Message Board

Home

Members

Calendar

Who's On

Welcome Guest ( Login | Register )

Inserting point field into an embedded xls...

Rate Topic

Display Mode

Topic Options

Author

Message

Jay Strauss

Posted 9/15/2006 9:22:12 AM

Forum Member

Group: Forum Members
Last Login: 12/5/2008 3:19:24 PM
Posts: 25, Visits: 41

Hi,

Does anyone know if I could insert my point field into an embedded Excel table in my word doc? That is, instead of inserting the field into the Word portion of my custom form, instead it would get put into the embedded Excel table within the word doc (custom form pcd)? So that I could do some fancy calculations Smile

I know I can export to a file, then use Excel on the data, but that's not what I'm looking for.

Thanks
Jay

Post #3892

mwm50

Posted 3/14/2007 4:04:42 PM

Supreme Being

Group: Forum Members
Last Login: 9/12/2008 11:24:50 AM
Posts: 289, Visits: 242

You can do this using VBA and the Excel object OLE model. It requires some object-oriented programming knowledge. You also have to trap the BeforeDocumentMerge and AfterDocumentMerge events so you can pick up the merge variables.

As long as you're doing this, you may as well do the calculations in VBA. It offers most of the financial formulas you would need.

-Scott

- Mike
mike@mtig.biz

Post #4585

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 0 (0 guests, 0 members, 0 anonymous members)

No members currently viewing this topic.

Forum Moderators: Emmanuel Huna, Bryan Telford, Jason Beck, Mike Thompson, BetaFisch

Permissions

All times are GMT -8:00, Time now is 12:57am