When recording a macro I am trying to open the Data Menu, select Refresh Data
a box opens you have to chose the file and Import. I want the code to have
the file name so it will import automatically without having to choose the
file each time.
This is the code now:
Selection.QueryTable.Refresh BackgroundQuery:=False
How do I put what file opens every time?

Thank you for your help,
Bob