MS Word merge macro selecting source

[saval]

Hello,

I am in need of some help with writing a macro.
We want to create a macro to merge an excel file in a word document.

Normaly this is not a problem if the name of the excel file is always the same. This however is not the case.

Is it possible to let a macro prompt to browse to the excel file needed as the source file.

Thnx in advance,

Paul

 

[PHV]

Take a look at the FileDialog object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244