Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. Getting a Filename from a Path
Sub open2()
     Set myWorkbook = Workbooks.Open(FileName:="C:\Data\SalesData1.xlsx")
     MsgBox myWorkbook.Name
End Sub