Access 97: Using Dde To Format Excel Cells

[DALIEN51]

Hi All,

Yes ok DDE may well be dead but it works for me so why change it? Basically I wondered what the commands where to format Excell cells. For example if I stamp a cell with todays date:

DDEPoke intChan1, "R3C2", Left(Now(), 10)

How would I say shade that cell black, change the lettering to white or underline or bold that cell?

Any help most appreciated.

Regards,

Dalien51

 

[ghudson]

Check this thread out and see how I alter an Excel file from Access...
hiding excel manipulations and showing a progress bar