Thanks Mayfield it worked. But how can I save the excel file,Currently Iam able to open the Excel file of my choice and paste some data into a specified cell. BR, Lann
Mayfield, Andy L. wrote: > > 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" > > -- View this message in context: http://www.nabble.com/Open-an-Excel-file-from-Remedy-tp18849160p18943064.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"
