Hi Brendan,



On 3 February 2012 09:39, Brendan Brink <[email protected]> wrote:

> Good morning,
>
> I am working on a project that requires the following:
>
> 1. Open existing .xls Excel spreadsheet (which contains macros)
> 2. Modify some basic cell data.
> 3. Save / export the new file while containing the original macros.
>
> The macros are NOT modified, they just need to be maintained when
> creating a new file.
>

PHPExcel is an awesome package, but it doesn't look like Macros will be
supported: http://phpexcel.codeplex.com/discussions/52723

That post is quite old, but this one supports the same message
http://stackoverflow.com/questions/5913818/phpexcel-clone-xlsm-with-macros.

Looks like you may have to use COM objects.


Kind Regards,

Jochen Daum

"There is no shortcut to anywhere worth going" - Beverly Sills

Automatem Ltd
Phone: 09 630 3425
Mobile: 021 567 853
Email: [email protected]
Website: www.automatem.co.nz
Skype: jochendaum
http://nz.linkedin.com/in/automatem
http://twitter.com/automatem

-- 
NZ PHP Users Group: http://groups.google.com/group/nzphpug
To post, send email to [email protected]
To unsubscribe, send email to
[email protected]

Reply via email to