ACC: Sample DDE Macro Communicates with Microsoft Excel 4.0 (97522)
The information in this article applies to:
- Microsoft Access 1.0
- Microsoft Access 1.1
- Microsoft Access 2.0
- Microsoft Excel for Windows 4.0
This article was previously published under Q97522 SUMMARY
Advanced: Requires expert coding, interoperability, and multiuser skills.
The text below demonstrates communication between two applications
through dynamic data exchange (DDE). Specifically, one example shows a
macro developed for Microsoft Excel version 4.0 for Windows that
starts Microsoft Access, loads a database and runs a macro. A second
example shows an Access Basic function that loads Microsoft Excel and
runs a macro.
REFERENCES
"Microsoft Excel Function Reference", version 4.0, pages 14 - 15
Modification Type: | Major | Last Reviewed: | 5/9/2003 |
---|
Keywords: | kbinfo kbinterop KB97522 |
---|
|