Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Smithy1001

    highlight dbgrid in D2010

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

    highlight dbgrid in D2010

    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...
  3. Smithy1001

    Excel Automation code optimisation With statement

    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...
  4. Smithy1001

    Delphi Excel Automation getting rid of .select for speed

    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...
  5. Smithy1001

    Delphi Excel Automation getting rid of .select for speed

    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...
  6. Smithy1001

    Delphi Win32 COM Excel problem

    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...
  7. Smithy1001

    Delphi Win32 COM Excel problem

    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...
  8. Smithy1001

    D2005 Crystal Win32 CRViewer

    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...

Part and Inventory Search

Back
Top