Re: [EXTERNAL] DDE Commands

[Carl Wilson]

e\Office11\winword.exe 

Application=winword 

Topic=system 

Format=CurrentFormat 

XFRDATA=Clipboard

Command1=[FileNew .Template="Normal", .NewTemplate = 0] 

Command2=[call Format_Change_Request]

 

 

Let me know if you need a Template with Macros that you can update, I also
have this available that did some funky things back in the day.

 

Cheers

Carl

 

http://www.missingpiecessoftware.com/

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Stroud, Natalie K
Sent: 31 July 2012 22:20
To: arslist@ARSLIST.ORG
Subject: Re: [EXTERNAL] DDE Commands

 

** 

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] On Behalf Of Stroud, Natalie K
Sent: Tuesday, July 31, 2012 3:31 PM
To: 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

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Mayfield, Andy L.
Sent: Tuesday, July 31, 2012 2:23 PM
To: 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 ARSlist: "Where the Answers Are"_ 

_attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ 

_attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ 

_attend WWRUG12 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"

Re: [EXTERNAL] DDE Commands

[Stroud, Natalie K]

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"

Re: [EXTERNAL] DDE Commands

[Mayfield, Andy L.]

I'm just not familiar with it. I may investigate that option if it's something 
I can pick up on myself.

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] On Behalf Of Rick Cook
Sent: Tuesday, July 31, 2012 3:57 PM
To: arslist@ARSLIST.ORG
Subject: Re: [EXTERNAL] DDE Commands

**

DDE is pretty much dead.  Why not use OLE?

Rick
On Jul 31, 2012 4:55 PM, "Mayfield, Andy L." 
mailto:almay...@southernco.com>> wrote:
**
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: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: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"_
_attend WWRUG12 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"

Re: [EXTERNAL] DDE Commands

[Rick Cook]

DDE is pretty much dead.  Why not use OLE?

Rick
On Jul 31, 2012 4:55 PM, "Mayfield, Andy L." 
wrote:

> **
>
> 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] *On Behalf Of *Stroud, Natalie K
> *Sent:* Tuesday, July 31, 2012 3:31 PM
> *To:* 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
>
> ** **
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] *On Behalf Of *Mayfield, Andy L.
> *Sent:* Tuesday, July 31, 2012 2:23 PM
> *To:* 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 ARSlist: "Where the Answers Are"_ 
>
> _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ 
> _attend WWRUG12 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"

Re: [EXTERNAL] DDE Commands

[Mayfield, Andy L.]

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] On Behalf Of Stroud, Natalie K
Sent: Tuesday, July 31, 2012 3:31 PM
To: 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

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Mayfield, Andy L.
Sent: Tuesday, July 31, 2012 2:23 PM
To: 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 ARSlist: "Where the Answers Are"_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

Re: [EXTERNAL] DDE Commands

[Stroud, Natalie K]

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

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Mayfield, Andy L.
Sent: Tuesday, July 31, 2012 2:23 PM
To: 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 ARSlist: "Where the Answers 
Are"_

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"