Hello Kristjan,
To all ARS developers who use DDE my advice is to switch to OLE Automation using custom-built OLE Automation Servers (ActiveX DLLs or ActiveX EXEs).
OLE doesn't have this limitation and offers you heaps more features and functions.
Say, in our company I automate MS Excel in the following manner:
1. Run search against Remedy User form and then drop data into MS Excel spreadsheet(either named range or just range of cells).
2. Use MS Excel financial and statistical functions to process data passed from Remedy User form and return results back.
3. Drop data into MS Excel chart (either pre-existing chart of create one on the fly) and either print chart out or send it via email as image file.
You can define the set of features you need from MS Excel in your company and then built your OLE Automation Server.
If you're intersted in this type of solution, let me know and I'll send you some code samples.
Regards,
Mikhail Gvozdev
Peregrine Product Support Engineer
Planwell Technology Australia Ltd.
1-5 Railway Street
CHATSWOOD NSW 2067
Phone: +61 2 9412 - 8763
Fax: +61 2 9419 - 7803
mailto:mikhailg@planwell.com.au
-----Original Message-----
From: Kristjan Aiaste - HELMES [mailto:Kristjan.Aiaste@HELMES.EE]
Sent: Monday, 22 April 2002 8:46 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: report - excel - DDE problem /// HELP!!
More on the topic.
I found the linefeed and carriage return stuff, but there is more
My database is MSSQL and as I have read it does not like the CR symbol.
I have tried this
REPLACE($Field1$,RIGHT( "
",1),"CR")
but I cannot save the damn thing then. Where is the error? It says it does not like the "CR" part...
anyone?
K.
-----Original Message-----
From: Kristjan Aiaste - HELMES
Sent: Monday, April 22, 2002 12:09 PM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: report - excel - DDE problem
Importance: Low
Hi Joel and everyone,
I tried the
REPLACE($TempDiary$,"
"," ")
command. However, this seems to only remove the CR, and not the linefeed. How can this be cropped?
K.
-----Original Message-----
From: Joel D. Sender [mailto:ARSlist@EARTHLINK.NET]
Sent: Sunday, April 21, 2002 11:10 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: report - excel - DDE problem
Importance: Low
Kristjan,
One way around this might be to set the description field
into a hidden/displayOnly field (step 1) and in the next action
set the hidden field to itself with the REPLACE function changing
the returns to spaces.
HTH,
Joel
At 05:32 AM 4/20/2002, you wrote:
Hi listers.
I am having a nasty problem.
I have a excel template for printing out a report or more like case details. I can open the excel file through DDE and poke values into cells, no problem..... UNTIL......
The problem is - I have a description field I'd like to poke into the excel cell, but it only pokes the first line (until ENTER). What can I do?????
Or maybe I should go a different route? Is there an easy way, I could open an MS Access DB/application through DDE and pass some sort of a value into a query that then generates a report in MS Access?? Like the requestID?
Please help me on this, I am in a bit of hurry already.....
Kristjan Aiaste
Joel Sender,
ARSlist Administrator
JDSender@earthlink.net
< http://www.ARSlist.org>
Director, Western Operations - QMX Services, Inc.
JSender@QMXS.com
Previous Topic
Index