Automation problem

[Boumxyz2]

I'm generating a report in Excel from Access. Once the report is done ( everything is automatic )access checks if the report already exists. If so it prompts the user if he wants to overwrite it or not. If yes is picked then I delete the file and save the report under the default name. If no is picked then I would like to show a common dialog(save as) and let the user decide where to save and the name of the new file. But the CommmonDialog control doesn't work ( or at least the VB6 common dialog ) in Access. I can't use the methods showSave, showopen and so on. Is there any way to do this without having to code a form to do it ? No need to give code, hints are great.

Thanks and best regards.
Nic

[Boumxyz2]

I found out how to do it thanks for your help though.

Nic