Ian,
Try this inserting this into your dde.ini file, the very last line includes a
paste and then a run, the run will execute an Excel macro called RemedyReport
that moves the data from the pasted cell to the desired locations on the
spreadsheet so you should take out the [RUN]("RemedyReport")] unless you have a
need to create and execute an Excel macro in your task:
[excelrecord]
Path=C:\Program Files\Microsoft Office\OFFICE11\excel.exe
Application=excel
Topic=system
Format=TAB
XFRDATA=Clipboard
Command1=[NEW(1)][PASTE()][SAVE.AS(,0)]
Command2=[OPEN("c:\temp\ProtoManualRequest.xls")][Paste()][RUN("RemedyReport")]
> Date: Wed, 6 Aug 2008 04:21:45 -0700
> From: [EMAIL PROTECTED]
> Subject: Open an Excel file from Remedy
> To: [email protected]
>
> Hello all,
> Iam trying to open a particular Microsoft Excel file in my F drive
> (F:\PPCR.xls),I want to copy some data from Remedy to particular cell of the
> Excel sheet say,A20.
>
> Iam using an Active link
> DDE- Action=POKE
> Service=EXCEL
> Topic=F:\PPCR.xls
> Item-A20
> Path-D:\Program Files\Microsoft Office\OFFICE11\excel.exe
> Command=[OPEN(F:\PPCR.xls)]
>
> The problem is it opens a new Excel sheet,not my file of choice.
> How can I remedy this?
>
> Thanks,
> Lann
>
> --
> View this message in context:
> http://www.nabble.com/Open-an-Excel-file-from-Remedy-tp18849160p18849160.html
> Sent from the ARS (Action Request System) mailing list archive at Nabble.com.
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
