Hi @mancucus, thank you very much for your continued help with this, it is greatly appreciated.

You are correct in your assumption i.e. that I'd like the files to be opened automatically

I tried the solution you kindly provided, and although I was able to select the folder to open, the code only opened the first file before displaying a '400' error.

I have however been thinking about this, and my sincere apologies for messign you around with this, but I wondered whether it would be possible to do the following:
  • I hard code this file path into the VB code 'Z:\CHRIS\Work\Monthly Extracts'.
  • Then, when when the user selects the macro, a dialog box will appear asking the user to type in the month.
  • Then, when they've entered this information and selected 'OK', the files in that folder will automatically open.
Once again my sincere apologies for messing you around.

Many thanks and kind regards