[PHP-WIN] Excel OLE Automation : accessing the Excel constants

2009-05-26 Thread Faubry, Samuel
Hi, I'm confronted to a new problem with Excel Automation: I don't manage to access the constants. For example, I want to find the last cell in a column: ExcelSheet.Range("C65536").End(xlUp) This fails because the constant xlUp is undefined... There is some user contributed notes about that pr

RE: [PHP-WIN] Excel OLE Automation using COM: file access problem

2009-05-25 Thread Faubry, Samuel
your documentation is more reliable. Thanks, Samuel > -Original Message- > From: Richard Quadling [mailto:rquadl...@googlemail.com] > Sent: Tuesday, May 19, 2009 5:28 PM > To: Faubry, Samuel > Cc: php-windows@lists.php.net > Subject: Re: [PHP-WIN] Excel OLE Aut

RE: [PHP-WIN] Excel OLE Automation using COM: file access problem

2009-05-18 Thread Faubry, Samuel
> From: Richard Quadling > 2009/5/18 Faubry, Samuel : > > Hi, > > > > I am interfacing PHP and Excel to build a web-based > reporting tool. I am running IIS6.0 with PHP 5.2.5 on Windows > Server 2003, with Office 2003 installed. > > > > For testing purpo

[PHP-WIN] Excel OLE Automation using COM: file access problem

2009-05-17 Thread Faubry, Samuel
Hi, I am interfacing PHP and Excel to build a web-based reporting tool. I am running IIS6.0 with PHP 5.2.5 on Windows Server 2003, with Office 2003 installed. For testing purpose, I wrote a script that just connects to Excel, opens a workbook, saves it under another name and closes Excel: