Hi

I have written a macro that pulls data in from an excel sheet and puts
it in a word doc.

I want to allow the user to select which excel file they want to use by
ideally using the common dialog control to allow them to navigate to the
file they want.

Is there any way of doing this, particularly without using a form to
trigger the dialog control.
I have had a look round the net and it seems a WinAPI call(s) are required.

Any help would be appreciated.

Thanks

Martin