Andy:
You might have better luck doing an initial dump via DDE, then having an Excel
macro manipulate the data and copy/paste it into a new spreadsheet. We had a
pretty fancy ticket metric report where the data would be dumped, then a macro
would manipulate (including creating several tabs) the data and create a bunch
of graphs. I was not the one who did all of that work, but it was pretty
amazing.
Here is a generalized section from our DDE.INI that ran the macro:
___________________________
[ReportName]
Path=C:\Program Files (x86)\Microsoft Office\Office12\excel.exe
Application=excel
Topic=system
Format=tab
XFRDATA=File
Command1=[OPEN("%f")]
Command2=[OPEN("\\server\share\other folders as needed to define
path\MacroName.xlsm")]
Command3=[RUN("MacroName.xlsm'!ReportName")
____________________________________
* Command1 does the dump from Remedy to Excel. - Note that this path is
for a 64-bit OS.
* Command2 runs the macro - include path the macro as well as the macro
name. Because several people were interested in this report, we kept our macro
out on a network share.
* Command3 generates the report using the macro.
Note that for a 32-bit operating system, you will probably need C:\Program
Files\Microsoft Office\Office12 instead for the Excel path. Additionally (and
whether your OS is 32 or 64 bit doesn't matter here), depending on what version
of Excel you are using, you may need a different number there in the path than
12. I believe 12 corresponds to Office 2007 and 14 corresponds to Office 2010.
I couldn't tell you for older versions, but you just need to make sure the
path matches where your excel.exe file is located.
Good luck!
Natalie
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Mayfield, Andy L.
Sent: Tuesday, July 31, 2012 2:56 PM
To: arslist@ARSLIST.ORG
Subject: Re: [EXTERNAL] DDE Commands
**
I use it now to dump results in excel.
I would like to try and also use it to dump results from Remedy into a
spreadsheet as well as open another spreadsheet, copy it's data and paste it
into another.
I'm not sure if it can do that or not, but I'm trying it out.
Andy L. Mayfield
Alabama Power Company
Protection & Control Technician Sr.
Linc # 10*19140
Cell # 205-288-9140
Office # 205-257-1556
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG]<mailto:[mailto:arslist@ARSLIST.ORG]> On Behalf Of
Stroud, Natalie K
Sent: Tuesday, July 31, 2012 3:31 PM
To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>
Subject: Re: [EXTERNAL] DDE Commands
**
Andy:
What are you wanting to do with DDE? If you need something basic like dumping
a Remedy report to Excel, I can give you a section from the DDE.INI file we
used to enable Excel in Remedy, but if you need to do something fancier than
that, I probably can't help you.
Natalie Stroud
SAIC @ Sandia National Laboratories
ITSM Tester
Albuquerque, NM USA
(505)844-7983
nkst...@sandia.gov<mailto:nkst...@sandia.gov>
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG]<mailto:[mailto:arslist@ARSLIST.ORG]> On Behalf Of
Mayfield, Andy L.
Sent: Tuesday, July 31, 2012 2:23 PM
To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>
Subject: [EXTERNAL] DDE Commands
**
Does anyone have, or know where I can get, a complete list of DDE commands for
Excel?
I'll settle for whatever information I can get.
Thanks,
Andy L. Mayfield
Alabama Power Company
Protection & Control Technician Sr.
Linc # 10*19140
Cell # 205-288-9140
Office # 205-257-1556
_attend WWRUG12 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers
Are"_
_attend WWRUG12 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers
Are"_
_attend WWRUG12 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers
Are"_
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
