Excel - DDE - Example

Step by step CMM-Manager tutorials
Post Reply
User avatar
US_Helpdesk
Moderator
Moderator
Posts: 1092
Joined: Wed Feb 23, 2011 7:26 pm

Excel - DDE - Example

Post by US_Helpdesk » Tue Jun 21, 2016 4:04 pm

See attached project file... This example shows how to export report data from CMM-Manager directly into Excel. DDE allows specifying an existing Excel sheet and cell address (row/ column), each time the program is executed the data is written to the specified cell.

For each report item a new DDE Operation is added to program as shown below. Note: Multiple report characteristics can be included in a single DDE output.
dde.jpg
NEW!!! DDE Excel Add-In NEW!!!

I've designed a new Excel Add-In that allows User to press [Ctrl + m] to copy Excel Cell "address" to clipboard. After cell data is copied, just place cursor in correct DDE field and paste value. No more manual searching and typing of Excel cell [row / column] address!!!

Install the attached Excel Add-In as follows:

Download Add-In here -
DDE_Addin.zip
Copy .xlam file to trusted location - C:\Program Files (x86)\Microsoft Office\Office14\ADDINS

Install Add-In from Excel Options>Add-ins>Manage: Excel Add-ins
addin_install.jpg
Once Add-in is installed just place the cursor in any Excel cell and press [Ctrl + m]
Excel_Cell_Address_Clipboard.jpg
You do not have the required permissions to view the files attached to this post.
I've migrated to a new user account, see my other posts here

Post Reply