Sorry, I've been away on vacation. You will need to add a second action to your Active Link to do the save (this will be a DDE EXECUTE and not a POKE). It would look something like this:
DDE- Action=EXECUTE Service=EXCEL Topic=system Path-D:\Program Files\Microsoft Office\OFFICE11\excel.exe F:\PPCR.xls Command= [SAVE()] Give that a try and see how it works. It should save the file with the filename you specify on the "Path" line. You can also have the file saved with a different name, but the syntax is a little different in that case. Let me know if you have any questions. 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: Tuesday, August 12, 2008 7:08 AM To: [email protected] Subject: Re: Open an Excel file from Remedy 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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
