jcsoybomb has asked for the wisdom of the Perl Monks concerning the following question:
I am trying to create a workbook in Excel using Spreadsheet::WriteExcel and I want to make it shared from the start. Does anyone know of the function call to do that? Alternately this can be done through Win32::OLE as I use that module later in the same script, however I don't know the call to set "Share Workbook" in OLE either.
Thanks in Advance.
I think that the ability to share a workbook is currently out width the scope of Spreadsheet::WriteExcel. If you can open excel and activate this feature, record it as a macro then convert the macro then see Re: Excel VB Controls for information how to convert VBA to Perl, since you're using Win32::OLE already.