I forgot to add, that to record the Macro, I'm clicking on the Data/Get from Text/CSV button, then getting the file, then choosing to Load to Table into the worksheet. Then saving, then stopping the Recording.
The data showing in the worksheet resulted from the Macro Recording run.
THEN, I went into the macro and edited the Path as suggested.