https://bugs.documentfoundation.org/show_bug.cgi?id=139939
--- Comment #3 from Harald Langheinrich <[email protected]> ---
copy without a target has destination activeworkbook and activeworkbbok has as
method .saveas
this is an example from microsoft
Worksheets(Array("Sheet1", "Sheet2", "Sheet4")).Copy
With ActiveWorkbook
.SaveAs Filename:=Environ("TEMP") & "\New3.xlsx",
FileFormat:=xlOpenXMLWorkbook
.Close SaveChanges:=False
End With
in open office with option VBASupport on this is also possible, but an error is
generated and the last page in the array disappears from the new workbook.
That's what i'm talking about.
if I use on error resume next everything is working as expected!!
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
