Merge to Workbook

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.

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.

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