Aspect DDE w/ Excel

[Unwired]

I am looking for Procomm Aspect DDE commands which will allow me to either run an excel macro on a specific sheet (not necessarily the active sheet) or just make a particular sheet active.

Also, I would like to be able to copy a sheet and rename it!

Any tips would be appreciated!

Rob

 

[knob]

If you look in the \Samples\ASPECT\DDE directory on your Procomm CD, there are two examples scripts (although I think they both perform the same exact functions) that do some basic manipulation of an Excel spreadsheet via DDE. It doesn't look like the scripts access a macro or set a particular sheet active, but maybe it will give you some ideas on how to solve your particular problem.