Hi,

I want to run a macro and then be able to choose files on my computer, then
save the chosen file location as a variable. Is there anyway to do this?

Sub Macro()
Prompt: Choose filename
Variable = Filename
End sub

Thanks for your help!