DDE Reference

[Richard]

Hi all,

Can someone please help me. I know how to access a
specific cell in excel through DDE. The format is for
example:

MSEXCEL|Sheet1!C1R1

Does anyone know the remote reference formula for a cell
in a table in MSAccess?

Thanks,

Richard

 

[Larry Linson]

DDE hasn't been current technology since Access 2.0, maybe Access 1.1. As I
recall, it didn't even work in Access 2.0 until the Service Pack/Release. I
don't know if it is still supported because I haven't heard it even
mentioned for several years.

Have you considered using COM Automation? It does work very nicely with
current versions.

Larry Linson
Microsoft Access MVP

 

[Richard]

Hey, thanks for the reply Larry. I'm not familiar with
com automation. Maybe it's what I'm missing in this
problem... What I'm trying to do is reference a cell in
Access so that it populates an Excel cell, so that when
ever the value in Access changes, so does the value in
excel.

Thanks for the help,
Dustin