Updating DDE Links Automatically


  
 Applies To 
  
 Product(s):MicroStation
 Version(s):08.05.02.35
 Environment: N\A
 Area: OLE
 Subarea: N\A
 Original Author:Bentley Technical Support Group
  

Problem

Updating DDE Links Automatically or in Batch Process.
Using the attached MDL and setting the Environment Variable 'PATH' to
the Source Program, all DDE Links will be updated via the Batch
Processor.

Product: MicroStation V8 2004 Edition
Version: 08.05.02.35
Area: DDE/OLE



Solution

This example will Automatically updated DDE Links using the Batch Processor.
-Place the UpdateDDE.bas in the Macro folder of the MicroStation Install.
-Add the Path of the Excel Executable into the Environment Variable for "PATH"
"If this Path is not added the Source Program has to be Opened during the Process"
Ex: PATH =C:\Program Files\Microsoft Office\OFFICE11\
-Create a Command File that runs the Key-in: MACRO UPDATEDDE
-Process all files that contain DDE Links against this Command File to Update Link.

*Note: UpdateDDE.bas is an Example & can be modified.

ftp://ftp.bentley.com/pub/knowledgebase/attachments/updateDDE.zip



See Also