I have a program that opens an Excel 2000 spreadsheet, reads several columns, then queries an oracle database using the values in each row of the columns to retrieve additional information, which I then write to a new worksheet in the workbook. This all works fine except that I allow the user...
Did you ever find an answer to your question on how to open a particular spreadsheet using the TExcelApplication component?
If not...
In my program I built a drop-down list of the visible worksheets and then when the user chose a worksheet from the list I opened it using the following code...
BCB 6 has several TExcel commonents, but it doesn't have any documentation on them. Can anyone please tell me how to use them to read data from and write data to an Excel 97 or 2000 spread sheet? I have seen the Delphi usage of these components, but I don't know Delphi so I really couldn't get...
When you set up the Start Application type of rule in Outlook, how does the application "know" what message activated it. I want to write a program that will process a incoming email and then have it move to a specific folder using the Rule Wizard rather than a macro or background...
So far all I've done is modify the results that the wizard produce. Strangely enough, adding support for vb function call with parameters and conditionally displaying certain buttons based on the person that logged into my application doesn't seem to prevent me from using the wizard from...
The Find function in the menu and button bar display a message box when there are no more matches for the specified search criteria. However, ths DoCmd.FindRecord doesn't do this, and none of the documentation I've seen so far on the DoCmd.FindRecord command covers how to determine if a match...
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.