I've got a spreadsheet that uses a DDE link to get 2 fields for an automatic
report. The DDE link is with a HMI/Scada package called CiTect.

My problem isn't the DDE link itself - that seems to be working perfectly.
My problem is when I run the automatic report the values printed in those
fields are #N/A#. The same value for both fields. When I view the report
that's printed the correct information is displayed.

To further complicate matters...if I'm viewing the report manually, and
click the "Print" button from the standard toolbar, everything prints out
exactly as it's supposed to including the DDE linked information.

I've written the code 2 ways

1) Sheet("Printout").Printout Copies:=1, Collate:=True

and

2) Sheet("Printout").Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True

Every time I try to run the automatic routine, both DDE linked cells are
printed as '#N/A#'

What am I doing wrong?

Thanks

Jeff