I am currently opening an excel file .. named as "MBB.xls"I wanna to create a button, where with VBA coding..once i click... it will came out as"Path name/MBB.xls"Basically i want to get the excel file name.. which file i am opening
Sub What_Am_I()Dim CompletePathName As StringCompletePathName = ActiveWorkbook.Path & "\" & ActiveWorkbook.NameMsgBox (CompletePathName)End Sub