Classification: UNCLASSIFIED Caveats: NONE This can be done in the following way:
1. Create a DDE.ini file in your Home directory 2. Copy the following into the DDE.ini text file [excelrecord] Path=c:\excel\excel.exe Application=excel Topic=system Format=TAB XFRDATA=Clipboard Command1=[NEW(1)][PASTE()][SAVE.AS(,0)] 3. Enable "Report to Application" option is selected in the Options dialog box 4. Build and save a report in the Remedy User tool 5. Choose Report > Export to > Application from the Report menu bar 6. Your query and created report will be sent to Excel 7. Tie this report to an Open Window action in an Active Link with a Button (Permissions: Public) Below is a web link with explains this in more detail: http://service-it-remedy.web.cern.ch/service-it-remedy/clients/aruser/Re ports15.html A description is also available in the Remedy User Tool help. You can also execute Visual Basic code. To do this you will need to substitute VB for the "Command1=[NEW(1)][PASTE()][SAVE.AS(,0)]" see VB Help for more detail. You will have to work with relative addressing in Visual Basic (a recorded macro in VB will give you static addressing). Gordon M. Frank DISA\Version FNS -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Anesh A Kurian Sent: Monday, November 19, 2007 7:30 AM To: arslist@ARSLIST.ORG Subject: Export Form Data to Excel on Button Action ** Hi Listers, I require to perform a data export of a regular form to an excel sheet on click of a button. And also that it shouldnt require the user to interact other than clicking the button. I tried by using the Open window action to run a report but here again it requires the user to select a format to which the data has to be saved as. i require that the workflow automatically opens an excel sheet and displays the exported data on to the excel sheet. i would appreciate if some one could shed some light on this or if anyone has done the same to share the idea. thanks and regards Anesh __20060125_______________________This posting was submitted with HTML in it___ Classification: UNCLASSIFIED Caveats: NONE _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
