I have been trying to figure out how to write a routine that will allow me to
activate a diffrerent sheet in excel. I am trying to do this in C++ (DLL
file). The problem I am having is there is not enough information out there
in reguards to using excel4 function. Is there anyone that can tell me how I
can do this.

Example VBA Equivelant:
sheets("Sheet2"). Activate

Need help on how to do this in C++.