Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
DDE Links...
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
DDE Links...
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 -- Message posted from http://www.ExcelForum.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
DDE Links...
Thanks. I'll try that tomorrow.
Jeff "KJTFS " wrote in message ... We have this problem at work sometimes with certain DDE's our quick and dirty fix was do a copy paste special (with only values) into another sheet then do the report from that sheet. Keith www.kjtfs.com --- Message posted from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
DDE Links...
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. "Jeff Harbin" wrote in message ink.net... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Slow opening links between workbooks with links created in 2003 | Excel Discussion (Misc queries) | |||
Update links box gives Continue or Edit Links dialog | Excel Discussion (Misc queries) | |||
Edit Links: Changing links on a protected worksheet | Excel Discussion (Misc queries) | |||
EXCEL - LINKS cannot easily get list of all links & names in book | Excel Worksheet Functions | |||
can't update links...can't find links | Excel Discussion (Misc queries) |