Mega Code Archive

 

Categories / VisualBasic Script / Excel

 

Getting a Filename from a Path

Sub open2()      Set myWorkbook = Workbooks.Open(FileName:="C:\Data\SalesData1.xlsx")      MsgBox myWorkbook.Name End Sub