Tuesday 8 June 2021

How to open another workbook by clicking CommanButton

 It is very Simple code

Private Sub CommandButton1_Click()

Workbooks.Open Filename:="E:\Excel VBA\Highlight Active Row.xlsm"

End Sub

by this code you can open particular files
E:\Excel VBA\ is the file path and Highlight Active Row.xlsm is the file name

No comments:

Post a Comment