mergeworkbook method - vba

[lezawang]

Hi
I am trying to merge 2 different files. The first file is hello1.xlsm (workbook1) in which i wrote the vba code below. hello1.xlsm is saved in the same folder of the second file which I want to merge it with, the second file called abc.xlsx. I got run time error - "method "mergeworkbook' of object _workbook failed". Any help would be very much appreciated.

Sub workbookmerge()
    Workbooks(1).MergeWorkbook "abc.xlsx"
End Sub

I followed this article

https://docs.microsoft.com/en-us/office/vba/api/excel.workbook.mergeworkbook

 

[DanteAmor]

Follow the steps to number 6, then run the macro.

https://support.office.com/en-us/ar...workbook-aa7c3598-5ad7-4fea-8c00-2daa7a934239



It also does the following:

- The book with the macro and the copy must be shared
- The book with the copy must be closed and in the same folder as the original book

Sub merge_book()
    'thisworkbook name is hello1.xlsm
    ruta = ThisWorkbook.Path & "\"
    ThisWorkbook.MergeWorkbook ruta & "hello2.xlsm"
End Sub

Regards Dante Amor

****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">follow the steps to number 6, then run your macro</body>