Andries This might help:
http://www.djpate.freeserve.co.uk/AutoExcl.htm See How to open a workbook Regards Steve -----Original Message----- From: [email protected] [mailto:[email protected]]on Behalf Of Andries Bos Sent: 27 November 2009 08:12 To: delphi advanced group Subject: [delphi-en] open an xls in a NEW appl. Hello I do have a rather simple application to open an xls file, change some cell values and to save this using a new name: All works well, except if there is already another xls file openened, it will 'grab' that file and change those cells. How could I force to open the NEW xls file and not to use an already openened worksheet. I use to openen my 'template' file: XLApp.Workbooks.Open(TemplateFile, EmptyParam, EmptyParam, EmptyParam, EmptyParam, EmptyParam, EmptyParam, EmptyParam, EmptyParam, EmptyParam, EmptyParam, EmptyParam, EmptyParam, 0); but this only works oke when no other xls sheet is already opened. I did find http://www.winsoft.sk/officfaq.htm but that does not provide any information on this topic. Any ideas as all google suggestions use the same command without mentioning already opened sheets.? regards Andries ________________________________ Slide scanning / dia's scannen vanaf / from E0,08c www.scancare.nl ________________________________ [Non-text portions of this message have been removed] ------------------------------------ ----------------------------------------------------- Home page: http://groups.yahoo.com/group/delphi-en/ To unsubscribe: [email protected]! Groups Links *************************************************************************** This e-mail and any files transmitted with it are confidential. If you are not the intended recipient, any reading, printing, storage, disclosure, copying or any other action taken in respect of this e-mail is prohibited and may be unlawful. If you are not the intended recipient, please notify the sender immediately by using the reply function and then permanently delete what you have received. Content of emails received by this Trust will be subject to disclosure under the Freedom of Information Act 2000, subject to the specified exemptions, including the Data Protection Act 1998 and Caldicott Guardian principles. This footnote also confirms that, unless otherwise stated, this email message has been swept by Sophos Anti-virus for the presence of computer viruses. ** Please consider the environment before printing this email. ** ***************************************************************************
