Merge to Workbook

[chetan]

Hi Everyone
I have opened 2 workbooks and during open event of libreoffice i want to merge these 2 open workbook together in one workbook. Can anyone share me a reference to perform this task.

I found one way to merge by writing a VB Macro, I am new to VB. Can anyone share me a reference source to perform this function or similar function.

[Lupp]

Remembering Can we import multiple XML file in Libreoffice

Don’t you think it’s a good idea to respond on comments / questions in return?
A forum isn’t one-way. If you created something related to a task, you probably should not only mention, but also offer it.

[erAck]

The easiest way is to do it manually in a few steps:

1. right click on a sheet tab for context menu
2. choose Select All Sheets
3. again right click on a sheet tab for context menu
4. choose Move or Copy Sheet…
5. Action Copy (preselected and can’t be changed if all sheets are selected)
6. Location To document, choose - new document -
7. hit OK
8. repeat for the second document to copy its sheets, but in Location To document choose the new Untitled 1 document (or the proper name if you saved it already after step 7) and the position where you want to insert the sheets