Re: Turn off ALL warnings question?

"Steve" <Steve@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:792CC9A8-8B62-4F62-9DE6-7D4D68EFA819@xxxxxxxxxxxxxxxx
> Does anyone know a way to turn of all warnings when using the Output to
> feature of a macro? I am trying to out but query results to a specific
> excel
> file. I always want to overwrite the current file but do not want to have
> to
> answer the question" File X already exists. Overwrite?" I tried using
> the
> Set warnings feature but that does not include this message. Any
> thoughts?


Why not first delete the file yourself if it exists?

If Len(Dir(strPath))>0 Then
Kill strPath
End If


.

Relevant Pages

  • Re: OT: Massachusetts Verdict: MS Office Formats Out
    ... Tim wrote: ... >> When I use OpenOffice, and want to save something that I created using ... foolish warnings such as the above "All might not be safe" ... If they don't use any non-exportable feature in a document, ...
    (Fedora)
  • Re: Per-source CFLAGS
    ... > appended to the command line after the global CFLAGS. ... > I intend to use this feature for gdtoa, ... Do you need to turn off all warnings or just ones for non-broken ...
    (freebsd-arch)
  • Re: image file locked after use
    ... I learned that there was a "feature" of GDI+ that keeps the source file locked after the image is loaded. ... Is there a way to unload this image so that I can overwrite it? ...
    (microsoft.public.dotnet.languages.vb)
  • Re: pragma warning
    ... >>> Using Win98SE, VC6sp5, ... >>> have warnings. ... >> Jeff Flinn ... > but a 'feature' of the particular function that I'm calling. ...
    (microsoft.public.vc.ide_general)
  • storing more than 300 auto text entries
    ... Great feature, but i can only input 100 entries, then i start to overwrite ... I am creating a directory of faults for an Electrical Company that a ...
    (microsoft.public.word.docmanagement)