DDE Reporting lots to different excel sheets

Post Reply
ameade022008
Power User
Power User
Posts: 76
Joined: Thu Oct 03, 2013 12:48 pm
Location: Tempe, AZ
Contact:

DDE Reporting lots to different excel sheets

Post by ameade022008 » Thu May 25, 2017 4:51 pm

Hello,

I am trying to elaborate on our reporting ability to our production parts. Currently we are Reporting via DDE to a Excel file that is in a known location, after that Lot(batch) is inspected, I open up that excel file and cut out my rounded results to paste it into the correct Job-->Lot-->ID number. I have VB scripting currently asking the Operators if they want to output the data, but it is getting tedious copying and pasting the information after it is collected into the corresponding job.

Is there anyway to have VB scripting or DDE in general run my program for that specific operation have a rolling File path to the new Excel File every time I run the program?

Basically what I would be looking for is to ask "Do you want to output DDE to excel?" and if the Operator says YES, it would prompt up the ability to have the operator choose the file path for that batch run.

I just dont want to have to edit the programs DDE file path every time we run that part number/operation.
Albert Meade
Quality Manager, Metalcraft Inc.
http://azmetalcraftinc.com/

ameade022008
Power User
Power User
Posts: 76
Joined: Thu Oct 03, 2013 12:48 pm
Location: Tempe, AZ
Contact:

Re: DDE Reporting lots to different excel sheets

Post by ameade022008 » Mon Jun 05, 2017 10:12 am

Bump
Albert Meade
Quality Manager, Metalcraft Inc.
http://azmetalcraftinc.com/

ameade022008
Power User
Power User
Posts: 76
Joined: Thu Oct 03, 2013 12:48 pm
Location: Tempe, AZ
Contact:

Re: DDE Reporting lots to different excel sheets

Post by ameade022008 » Mon Jun 05, 2017 10:33 am

This is currently where I am at:

https://www.youtube.com/watch?v=niUv8-n6N8s
Albert Meade
Quality Manager, Metalcraft Inc.
http://azmetalcraftinc.com/

User avatar
Ryan Christopher
Nikon
Nikon
Posts: 248
Joined: Mon Jun 06, 2011 3:00 pm
Location: Sumner Washington
Contact:

Re: DDE Reporting lots to different excel sheets

Post by Ryan Christopher » Mon Jun 05, 2017 11:17 am

Prolink is great at data archival and creating custom reports.... (and it's not very expensive)

http://www.prolinksoftware.com/
Ryan Tackes
Applications Manager, VMS Inc.
http://www.vantagemeasure.com/

ameade022008
Power User
Power User
Posts: 76
Joined: Thu Oct 03, 2013 12:48 pm
Location: Tempe, AZ
Contact:

Re: DDE Reporting lots to different excel sheets

Post by ameade022008 » Mon Jun 05, 2017 12:28 pm

Looking for a fix within CMM-M, if there is one. I have gotten pretty good at outputting DDE on all my programs to Excel formats I already have.

Would hate to learn yet another software.
Albert Meade
Quality Manager, Metalcraft Inc.
http://azmetalcraftinc.com/

ameade022008
Power User
Power User
Posts: 76
Joined: Thu Oct 03, 2013 12:48 pm
Location: Tempe, AZ
Contact:

Re: DDE Reporting lots to different excel sheets

Post by ameade022008 » Thu Jul 06, 2017 4:20 pm

Any Update to this? I've noticed now if I leave my excel open during DDE, CMM-M will create another excel spreadsheet on the local computer vs going to the actual linked directory on my network drive.
Albert Meade
Quality Manager, Metalcraft Inc.
http://azmetalcraftinc.com/

User avatar
CrashN8
Site Admin
Site Admin
Posts: 519
Joined: Thu Feb 09, 2017 4:07 pm

Re: DDE Reporting lots to different excel sheets

Post by CrashN8 » Thu Aug 10, 2017 11:24 am

ameade022008 wrote:Basically what I would be looking for is to ask "Do you want to output DDE to excel?" and if the Operator says YES, it would prompt up the ability to have the operator choose the file path for that batch run.

I just dont want to have to edit the programs DDE file path every time we run that part number/operation.
Just add External Command (robocopy) to end of program to copy Excel file as needed. Set up DDE to overwrite the cell each time, and then make a copy of the Excel file into your specified path.

See example here - https://cmmmanager.com/forum/viewtopic.php?f=31&t=1513

Post Reply