DDE Programming - Remembering the spreadsheet location?
Hey all:
When setting up DDE operations, is there a trick to getting the software to remember the location for the spreadsheet that you're dumping your data in? My work flow is usually to setup the Excel file first, then start creating the operations. So my first DDE operation will dump the first data point as well as the part number, sequence number, etc. from the report header information.
Then when I move down to the next report item and start to setup a DDE operation for it, in the bottom of the DDE box, the Excel file isn't there, and when I click on the three-dot-button for the path, the path is set to some seemingly random folder and hasn't updated. So every time I create an operation, I have to switch over to a Windows explorer window and copy the folder path from the address bar so that I don't have to navigate my way to the Excel file.
Is there a trick to getting CMMM to "remember" the path for the file in the operation that I just finished setting up? Seems like a hassle and that I'm missing something.
VErsion is 3.10.1
Thanks!