P
PO
Hi
Is there a way to directly create an object referens to the created workbook
in excel when using the ssExportActionOpenInExcel action?
After the OWC Spreadsheet is exported I want to perform a pagesetup on the
newly created worksheet.
I've tried to use a workaround - Spreadsheet1.ActiveSheet.UsedRange.Copy. I
then create an Excel.Application instance and paste the data. The problem is
that, for instance, autofiler-settings and columnwidth-settings don't get
copied. So, besides copying and pasting the data several settings need to be
recreated on the Excel instance.
Yet other workarround uses the ssExportActionOpenInExcel, for instance
Sp1.ActiveSheet.Export "C:\Report.xls", c.ssExportActionOpenInExcel.
Thereafter I create a Excel.Application object instance and open
C:\Report.xls. The problem here is that this limits the users options to
choose another name for the report.
Therefor, the easiest way would be to create the referens when the
ssExportActionOpenInExcel action is invoked, for instance:
Set xlw=Sp1.ActiveSheet.Export("C:\Rapport.xls",
c.ssExportActionOpenInExcel)
(this doesn't work)
Any ideas?
TIA
PO
Is there a way to directly create an object referens to the created workbook
in excel when using the ssExportActionOpenInExcel action?
After the OWC Spreadsheet is exported I want to perform a pagesetup on the
newly created worksheet.
I've tried to use a workaround - Spreadsheet1.ActiveSheet.UsedRange.Copy. I
then create an Excel.Application instance and paste the data. The problem is
that, for instance, autofiler-settings and columnwidth-settings don't get
copied. So, besides copying and pasting the data several settings need to be
recreated on the Excel instance.
Yet other workarround uses the ssExportActionOpenInExcel, for instance
Sp1.ActiveSheet.Export "C:\Report.xls", c.ssExportActionOpenInExcel.
Thereafter I create a Excel.Application object instance and open
C:\Report.xls. The problem here is that this limits the users options to
choose another name for the report.
Therefor, the easiest way would be to create the referens when the
ssExportActionOpenInExcel action is invoked, for instance:
Set xlw=Sp1.ActiveSheet.Export("C:\Rapport.xls",
c.ssExportActionOpenInExcel)
(this doesn't work)
Any ideas?
TIA
PO