Recent content by Smithy1001

Hi Imex, Yes that did the trick, it is selected now. Many thanks Paul

Hi, I have a text box that the user can type in a number and then presses a button. I also have a dbgrid with a list of number in. I can look through the dataset and find the number. I can even select that row. I cannot get that row highlighted or simulate an on click event on that row...

Hi I am using late binding with excel. I cannot use the following scenario. I have even tried putting ws.pagesetup as a variant. ws.pagesetup.centerheader := 'This works'; //GOOD with ws.pagesetup do //FAILS HERE begin CenterHeader := 'This does not'; end; I have seen examples...

Hi, I am late binding. I have not turned off screen updates but I will. I cannot select the whole range of cells as it's only every 13th row of 5000 rows that I want the 2 conditional formatting lines on, so it's row 10,23,36 etc (ie 10+x*i). Also I cannot use the following scenario. I have...

Hi, I use delphi to manipulate excel and frequently format cells iteratively. I am told that using say range['A1'].select and then excel.selection.value:= etc is time consuming and the best way is to put just range['A1'].value:= as the select process takes time. So, I have the following code...

Hi, thanka for the information but I am using late binding and my question is How do I copy a template workbook to an open fresh blank workbook using late binding? This then enables me to work on a workbook that is open, not presaved and does not need to be saved to a local drive in advance...

Hi, I am using D2010, Win32, COM to communicate with Excel. The plan for my app is to have an excel template in a folder on our server which is pre-formatted, to open that file, copy the formatting to an open workbook which I create on the fly and then close the template. This gets round the...

I have a win32 app in D2005 and I have managed to use the RDC using a variant call etc. My problem is getting the CRViewer into the WIN32 component palette. I have created a unit from it called CRVIEWERLib_Tlb which I can create an instance of the componentat runtime, but I cannot interact...