I have an Excel file (which is linked to a text file) that is linked to my Access database. Can I create a macro to copy the text file from the source, refresh the Excel file to match the text file, then save and close the Excel file?

I attempted this to open, refresh, close, and save the Excel file but it isn't refreshing:
Please Login or Register  to view this content.