Hi Dave, Thanks for the quick response 8-o You just got in before I came clean and admitted that I had deleted the type libraries by mistake (always read the instructions before running registry cleaners ;-)
Ran the Office setup in repair mode and fixed the problem. Thanks again to all who have/are in the process of replying. Paul. --- In [email protected], David Smith <[EMAIL PROTECTED]> wrote: > > Is there something unusual about that spreadsheet? I'd look at any VB code in that module making API calls or loading DLL's and the like. > > Dave > > Paul Bennett <[EMAIL PROTECTED]> wrote: Hi all, > > I seem to have developed a strange problem with the TExcelApplication > component. > > Background. > > I have an application that takes data from a 3rd party application and > bridges it to a series of Excel spreadsheets. The application uses a > series of Jedi plugins, one for each of the spread sheets. > > I have shipped the Application and 2 plugins to our production office > where it is running successfully. > > The Problem. > > Production wanted another spreadsheet so I have created another > plugin, based on the previous 2, all runs well until I get the the > WriteSpreadsheet routine, where for some reason I get an > EIntfCastError when I try to connect to the Spreadsheet. > > I've also tried running the other plugins, but get the same error. > I'm assuming that I have some problem with Excel itself, but have been > unable to resolve it so far. > > Any help would be much appreciated. > > Paul Bennett > > > > > > > --------------------------------- > Looking for last minute shopping deals? Find them fast with Yahoo! Search. > > [Non-text portions of this message have been removed] >
