DDE Links...

J

Jeff Harbin

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
 
K

KJTFS

We have this problem at work sometimes with certain DDE's our quick an
dirty fix was do a copy paste special (with only values) into anothe
sheet then do the report from that sheet.

Keith
www.kjtfs.co
 
J

Jeff Harbin

I got around the problem. I'm posting this to help others who might make
the same mistake I did. The entire code was written in an Auto_Open()
macro. Everything - including the print routine and the closing routine -
was run in the Auto_Open macro. What I realized is that the spreadsheet
wasn't evaluating the DDE links until after the macro had concluded. By
that time I'd already printed out the report that was supposed to contain
the DDE information.

I got around this by using the Application.DDEInitiate, DDERequest, and
DDETerminate commands directly in the code and then programmically populated
the appropriate fields with the appropriate info.

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

print 2 sheets on one paper 5
Pop Up Message before printing 3
Print Code 8
Print two different areas on a worksheet 5
DDE Links 0
Printing Macro 4
Data logging with a DDE link and VBA 5
Print Code Help 5

Top