DDE with Excel

[Riegg]

Can I make a script do a save as/open with a string var??

i.e.: ddeexecute systemvar "[save.as(filename)]"

 

[Riegg]

ok here is what I have done:

filename = "`"[open(`""
strcat filename sdirectory
strcat filename sfile
strcat filename "`&quot]`""
ddeexecute systemvar filename
pause 1

That works but if I do filename = "`"[save.as(`"", it won't work??

 

[FastLearner]

The following string passed to Excel via DDE will properly execute the save.as macro comand. Note that the filename has quotes around it.

[SAVE.AS("testsave.xls&quot]

So, the following SHOULD work via Aspect.

macrostring="[SAVE.AS(`"testsave.xls`&quot]"
ddeexecute systemvar macrostring

For some excellent general DDE info, look here:

http://www.angelfire.com/biz/rhaminisys/ddeinfo.html

To get a copy of the Macro97 help file, look here:

http://support.microsoft.com/support/kb/articles/Q143/4/66.asp

If you don't have the Macro97 help file already, I HIGHLY recommend grabbing a copy. It really opens up the doors to what you can do with Excel via DDE.


Note: I did not test this via Aspect, but used Python's interactive interpreter with the DDE module loaded as it returns the results immediately. It provides a nice real time test. The only problem I encountered was when the quotes were omitted.

 

[Riegg]

Thanks for the help, I missed the fact that I was using the wrong DDE ch (it was linked to the sheet tab not to system) once I changed that all my problems went away.