I want to be able to ask the user to point to a file (when running a macro
and without opening the file) and for the directory structure and filename
location to be stored in a variable within my VB code to be used at different
points later in the macro.

I have tried 'variable name = Application.Dialogs(xlDialogOpen).show'
but this opens the file and stores the value TRUE in the variable.

Can this be done?

Kelford