DDE Reference

  • Thread starter Thread starter Richard
  • Start date Start date
R

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
 
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
 
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
 
Back
Top