Excel Export Prompting to Overwrite.

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Chuck (anonymous_at_discussions.microsoft.com)
Date: 05/05/04 

Date: Wed, 5 May 2004 09:39:36 -0700

Hello,

I have a command button that I want to have export a
query to Excel. It exports a different query based on
the selections the user picks. I have it working except
it does not prompt the user if the want to overwrite the
file or not, it just does it automatically. I created a
macro to do the export. If I run the macro from the
database window it does prompt for an overwrite. If I
use the DoCmd.RunMacro command in VB it does not prompt
to overwrite. Is there a way to make the RunMacro
command prompt for an overwrite? Or is there a way to
make the OutputTo command prompt for overwrite?

Thanks,
Chuck

Quantcast