Vba button to open another workbook from the same folder

[aerobharath15]

hi,

I have a folder template called "QUOTE 1" inside which i have 1.xlsm and 2.xlsx excel files. I'm setting up a macro 'button' in 1.xlsm to open 2.xlsx from the same folder.

Please can you provide a vba code to achieve this?

Please note that I will duplicate folder template and rename. So the macro should always open 2.xlsx from the same folder as 1.xlsm irrespective of the folder name.

thanks in advance.

 

[daverunt]

Try this.

Workbooks.Open(ThisWorkbook.Path & "\2.xlsx")