[Date Prev] [Date Next] [Prev in Thread] [Next in Thread] [Date Index] [Thread Index]

Re: DDE - Annoying blank line



**

It's because you're using Format=TAB, which forces the data into columns,
with a column title.  Even if you blank out the field's report label, it
provides a line for it.

Instead, use Format=Record

hth-
-Aaron


-----Original Message-----
From: Harrodine, Sean [mailto:sharrodine@EMEA.ATT.COM]
Sent: Wednesday, October 02, 2002 6:29 AM
To: ARSLIST@LISTSERV.QMXS.COM
Subject: DDE - Annoying blank line


**

Hi there,

I have a report with basically everything set to null, and am using the
following DDE setup ........

Application=Excel
Path=c:\progra~1/micros~1/office/excel.exe
Topic=system
Format=TAB
XFRDATA=Clipboard
Command1=[OPEN(C:\PCInfo\test.xls)]
Command2=[WORKBOOK.SELECT("Test")]
Command3=[PASTE("R3C3")]

So, the results which is just a ticket number should go into cell C3 ????

Wrong....mine for some reason goes into C4 with a blank in C3 !

Does anyone know where my blank will be coming from please ???

As i said, title,header,footer,margins,seperators etc etc are either set to
NULL values or 0.


Help greatly appreciated.......................

____________________________________________________________________________
_____________
You may control your subscription options, including UNSUBSCRIBE,and ACCESS
THE ARCHIVES at http://www.ARSLIST.org

_________________________________________________________________________________________
You may control your subscription options, including UNSUBSCRIBE,and ACCESS THE ARCHIVES at http://www.ARSLIST.org