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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.