I am new to using VBA and am looking for some help. I have created an excel file with VBA code in to format data, and auto send the completed file as an email. This file will be used by several people and is stored on SharePoint/OneDrive.

The initial csv file will be downloaded by users to their own downloads folder so I am looking to create a module that will move the csv from C:\Users\*\Downloads to the current directory in which the excel file is open in.

Any help would be gratefully appreciated.
Thanks