Hi All,

I have a report to do for my manager and I am having some trouble with the
DDE call. I record a macro that does the search, grabs the results, exports
it to clipboard, and Book1.xls file opens. Then the excel macro pastes the
information into the spreadsheet.

Because of formating, I would like to do is call up a different spreadsheet
(Report1.exe). The Admin Guide refers to the following

Command1 = [NEW (1)] [Paste ()] [Save.As (,0)]

Command1 = [OPEN ("%f)]

Can anyone tell me which to use with an example. Also how do you use the %N
and %F variables, as I can't seem to make them work???

This is what is in my dde.ini file
[DDECall]
Path = D:\Program Files\Microsoft Office\Office\excel.exe
Application = excel
Topic = system
Format = Tab
XFRDATA = Clipboard
Command1 = [PASTE ()]
Command2 = [RUN("PERSONAL.XLS!testmacro")]

Thanks

Mark


>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
MARK BRITTAIN
Team Leader/Remedy Developer
Customer Support Center
AppliedTheory Corporation
800.727.0793

_____________________________

Mark,

I have done what I think you are trying to do. the %f variable is the name of the file you are trying to open. It must be a fully qualified MS-DOS(8.3) filename.

This is what I would suggest for your dde.ini file
[DDECall]
Path = D:\Program Files\Microsoft Office\Office\excel.exe
Application = excel
Topic = system
Format = Tab
XFRDATA = Clipboard
Command1 = [OPEN (d:\fullpath\Report.xls)
Command2 = [PASTE ()]
Command3 = [RUN("PERSONAL.XLS!testmacro")]


I hope this helps.





In Perfect Love and Perfect Trust,
Robert
Earn a dime every time you receive email!
Sign up FREE at: http://www.MintMail.com/?m=660882
http://www.sixfigureincome.com/?537996

_____

Chat with friends online, try MSN Messenger: Click Here

_____________________________

Hi,

Don't know if this has ever been mentioned before...

When specying DDE commands in your DDE.ini, you can use most of the old Excel Macro language
commands (What was used before VBA came along). These functions are documented in the XLmacr8.hlp
helpfile (I had to get it off Microsofts Site).

Here's an example of some neat stuff I've been doing with it:

[ExcelAppendData]

Path = c:\Program Files\MsOffice\Office\excel.exe
Application = excel
Topic = system
Format = Tab
XFRDATA = Clipboard
Command1 = [WORKBOOK.SELECT("Data")][SELECT.END("R1C1")]
Command2 = [SELECT.END(4)][SELECT(, "R[1]C")][PASTE()]

This would append data to the end of a existing set of data on sheet "Data".

Makes for some interesting possibilities with DDE actions to.

--
Jeromy Reed

CGI-Application Management Services
Consultant - CSB Remedy Applications

Tel #.: (514) 878-8700 x1316
Fax #: (514) 215-1025

http://webhost02.on.bell.ca/cgitelecomremedyhd4/

1800 McGill College Avenue, fl14
Montreal (PQ), H3A 3J6
--


Mark Brittain wrote:
>
> **
>
> Hi All,
>
> I have a report to do for my manager and I am having some trouble with the
> DDE call. I record a macro that does the search, grabs the results, exports
> it to clipboard, and Book1.xls file opens. Then the excel macro pastes the
> information into the spreadsheet.
>
> Because of formating, I would like to do is call up a different spreadsheet
> (Report1.exe). The Admin Guide refers to the following
>
> Command1 = [NEW (1)] [Paste ()] [Save.As (,0)]
>
> Command1 = [OPEN ("%f)]
>
> Can anyone tell me which to use with an example. Also how do you use the %N
> and %F variables, as I can't seem to make them work???
>
> This is what is in my dde.ini file
> [DDECall]
> Path = D:\Program Files\Microsoft Office\Office\excel.exe
> Application = excel
> Topic = system
> Format = Tab
> XFRDATA = Clipboard
> Command1 = [PASTE ()]
> Command2 = [RUN("PERSONAL.XLS!testmacro")]
>
> Thanks
>
> Mark
>
> >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
> MARK BRITTAIN
> Team Leader/Remedy Developer
> Customer Support Center
> AppliedTheory Corporation
> 800.727.0793
>
> _____________________________
>
>

_____________________________