Any question answered...

You are reading a single comment by @salmonchild and its replies. Click here to read the full conversation.

•

aggi in reply to @salmonchild

I have it in my Personal macro workbook. When you run it it will bring up a dialogue box to let you pick the folder where the files you need to do the work on are.

Or you can just save it in any random workbook and run it from there. These instructions should be OK if you're not familiar with running macros https://searchengineland.com/how-to-use-macros-you-find-online-in-6-easy-steps-137786

•

salmonchild in reply to @aggi

Cheers, used to running them but can only decode about a third of that so couldn't understand how the path was specified. Will give it a go shortly.

•

aggi in reply to @salmonchild
```
With Application.FileDialog(msoFileDialogFolderPicker)
    .Show
    Pathname = .SelectedItems(1) & "\"
End With
```
Specifies the path. It's a nice bit of code for inserting in any macro where you want a path.

About

Avatar for salmonchild @salmonchild started