VBA to open file copy text from file into excel.

[bigbeat85]

My end goal is to create a tool for different users so that when a button is pressed;

the different users can select a varying name of file from their own C drive Download file
The name of the file will differ daily
Import it into excel then run code (which i have correct)
and save to another location on a networked folder to be used for Power BI

I have the below for opening the file so far

Dim FileToOpen As Variant
FileToOpen = Application.GetOpenFilename(Title:="Browse for your File & Import Range", FileFilter:="Excel Files (*.xls*),*xls*")
If FileToOpen <> False Then

End If