Anyone know how to close down (if open) the child windows of another application from Excel VBA?

DominicYour method looks great and much cleaner but I can't get it to compile. Also I need to create this as a DLL. I'm using Excel 2002 but don't have the mso9.dll, vbeext1.olb or excel9.olb installed on my machine. Where are they on yours?PW

Does anyone have any C++ code that I could experiment with as a DLL function for simply setting an Excel cell to a given value/text using DDE (not automation)?e.g. Workbook1 Worksheet1 Cell A1 = "YES"

thanks Jens, your help was invaluable.I was using char * and the following worked fine:USES_CONVERSION;rVal.vt = VT_BSTR;rVal.bstrVal = ::SysAllocString(A2OLE(strptr));VariantCopy(&xlvalue, &rVal);VariantClear(&rVal);RegardsPW

<t>I'm using the VB-toVC automation code converter to help me create a dll function that places some text into an excel spreadsheet cell.If I want to send "YES" then it produces: rVal.vt = VT_BSTR;rVal.bstrVal = ::SysAllocString(L"YES");VariantCopy(&xlvalue, &rVal);VariantClear(&rVal);do...

Dominic: thanks and please send to optimization@btinternet.comJen: this sounds great but I can't (1) figure how to click through the hierarchy and (2) where to find a VB2VC automation converter (searched MSDN).

Thanks Dominic please send to: optimization@btinternet.com

<t>Thanks Jens but I was trying to find something that would allow me to update a given cell on a specific worksheet (using the #import automation method) ...(this code is ok)pXL.CreateInstance(L"Excel.Application.9");pXL->Visible = VARIANT_TRUE;WorkbooksPtr pBooks = pXL->Workbooks;_WorkbookPtr pBoo...

Dominic, using #import do you know how to reference a specific worksheet other than active worksheet?ThanksPaul

<t>Apparently there are 3 ways to automate Excel from VC++ - MFC, #import, and C/C++. Although not yet working, Dominics #import method seems to be the quickest option when using a DLL.However, referencing using #import can be a pain.Does anyone know how to activate e.g. "Sheet2" before updating a s...

thanks for the code. I'm using VC6 which unfortunately throws up lots of errors when compiling. I'll give it a try and post the corrections if I can sort it out.

I'm trying to create a DLL function in MS VC++ that when called will simply place a given value in the cell of an Excel spreadsheet. Can anyone provide the code?

yes I'm just trying to set the value of a cell in the spreadsheet to a number or text.ThanksPaulWilliams

I'm trying to create a DLL function in MS VC++ that when called will place a value in an Excel spreadsheet. Can anyone provide the code?