Thanks Tom and Ed, used the code once I understood there was Open and
OpenText.

Thanks again. Rob
"Ed" wrote in message
...
Hi, Rob. Check out the VBA Help for Dialogs Collection Object, Dialog
Object, and Show Method and Show Method Example. One important fact is
that
the Show Method returns True if a file is opened and False if the user
hits
Cancel.

HTH
Ed

"Rob" wrote in message
...
Excel 2000

I have recorded a macro to open a txt file and then carry out some
formatting, my need is however to run this on several files each with a
different name. How can I display the open file dialog window, select
the
file and then run my macro? If I cancel the open dialog window I won't
want
to run the macro.

Hopefully this makes sense!

Thanks, Rob