I have a master wookbook that need to update weekly. The new information
comes from a file that sent to me every week(the name of the file changes to
reflect the updated date). I want to use macro to automate this process.
Everything work out fine but I don't know how to change the file name in
macro.

Any advice is highly appreciated.

Jason