Trying setting up your active link as shown below:

DDE- Action=POKE
Service=EXCEL
Topic=sheet1 (or whatever your excel sheet is named)
Item-R20C1   (this is cell A20)
Path-D:\Program Files\Microsoft Office\OFFICE11\excel.exe F:\PPCR.xls
Command= $FIELDNAME$

Andy L. Mayfield 
Sr. System Operation Specialist 
Alabama Power Company 
Office: 205-226-1805 
Cell: 205-288-9140 
SoLinc: 10*19140 


-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of lann
Sent: Wednesday, August 06, 2008 6:22 AM
To: [email protected]
Subject: Open an Excel file from Remedy

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"

Reply via email to