File picker help

[shrubfact]

Hi

I have a file that I would like to open using VBA and then copy column a, then paste into my worksheet column d to update it

The file I want to open is in a shared file and there is a choice of week to select

eg.

the macro would follow the file path and then prompt to choose the required week file, then when the week file is selected it will open and copy column A and paste into column D of my worksheet then close the selected week file

Any help appreciated

[BellyGas]

Firstly, use the macro recorder to record yourself completing all these actions manually, then you'll have some base code to work with.

You can use the command GETOPENFILENAME to prompt a user to select the file to open, see here: https://msdn.microsoft.com/en-us/lib.../ff834966.aspx

And here is how you specify the directory it starts in: https://social.msdn.microsoft.com/Fo...e?forum=isvvba