DDE Functions to open, save, rename, add sheets, etc.

[mikie99]

I'm new here, but not to programming. But... I've not spent much time creating Excel files in programs I've written. I've inherited a program that reads a few excel sheets and creates a new excel file. This works fine. I need to add the functionality to rename this file, as well as open an existing file and add data to different worksheets.

I've looked through Microsoft's documentation, I can't find the functions I need. I can't even find the ones that I'm using. I'm sending commands through a dynamic data exchange (DDE) and maybe I'm just not looking in the right place.

Some of the commands I'm using now:

sprintf(excel_buff, "[NEW()]");

sprintf(excel_buff, "[SELECT(\"R%dC%d\")]", 1, 2);

sprintf(excel_buff, "[FORMULA(\"J1\")]");

I can't find any info on these, or what I want to do; change sheets, rename sheets, and save to a different filename.

[mikie99]

I found one so far. I searched the web far and wide to find:

SAVE.AS()

Nobody has interfaced to Excel thru DDE before?

[mikie99]

And

WORKBOOK.SELECT()