Thanks Steve - I'll give it a go - Regards Jeremy

Thanks All Clearly they still perform a role. I must have been lucky with the various monitors I've had over the last ten years or so that have survived without a screen saver. Regards Jeremy

Okay, so for recent contests look here: http://www0.us.ioccc.org/main.html[^] People that start writing code immediately are programmers (or hackers), people that ask questions first are Software Engineers - Graham Shanks

Thanks Rich That sounds like the way to do it. I'll have a go at it. The variable may, however, revert to null once the function that performs the calculation goes out of scope. Regards Jeremy

JSadleir wrote: how would a network administrator handle an unsigned Excel Add-in that needs to be accessed by several individual computers on the network? Just share it from the server machine and import this add-in in an excel.

Wanna bet? %ProgramFiles% Try typing SET at a CMD prompt. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Brilliant!! Many thanks for that!

Sorry Chris - I copied out part of the code incorrectly here is what it should have been - Thanks Jeremy BSTR __stdcall SomeFunction(LPSTR cSPC) CHAR cTheString [255]; BSTR bResult; UINT iStringsLength=0; strcpy(cTheString,"Absolute Return"); iStringsLength = strlen(cTheString); bResult = SysAllocStringByteLen(cTheString,iStringsLength); return bResult; }

Many thanks RainbowWyrm - Yes, I had left out - Thanks again

JSadleir wrote: Clean - Deletes all the intermediate files. and also the output files! Rebuild: Same as Clean, but a new Build is launched after it. Build: Compile all changed files and link. Build doesn't say anything about pre-compiled header files. Don't try it, just do it! ;-)

XLCALL32.lib is an object library, not an 'inline file'. An object library is a collection of object modules, compiled previously. From the Project menu, select Properties. In the dialog, select Linker and then Input. Add XLCALL32.lib to the Additional dependencies field. Software Zen: delete this;

Blake Miller wrote: You still have to get the valuess INTO the map, so how does that provide any gains over the switch statement? The gains are in the area of maintenance, not necessarily performance. For large switch statements a map lookup is easier to understand and therefore easier to maintain. A map lookup is more robust (i.e. less error-prone, dure to factoring) if the switch is needed more than once. As you have already pointed out, a map allows run-time initialization and is therefore more flexible. /ravi My new year's resolution: 2048 x 1536 Home | Articles | Freeware | Music ravib@ravib.com