Turning off messages

[Statistician]

Hi all,

I have set up some access VBA code to convert an excel file to a csv but keep getting the regular messages asking whether you want to keep the existing format etc...

Does anyone know of a way to turn these messages off or to automate responses to these prompts.

I am trying to minimise as much user input as possible and to automate the process to the fullest.

Thanks in advance for any help offered.

Dee

 

[PantoKing]

Try
Docmd.SetWarnings(False)to turn them off.
But don't forget to turn them back on by changing False to True when you've finished. :-V

Cheers,

Steve Make things as simple as possible — but no simpler.

 

[jojones]

what command are you ising to change the format of the file.

Jo Cheers
Jo Jones

 

[jojones]

Sorry - wasn't answering your question, just that I am unaware of a convert method. are you using SaveAs? Cheers
Jo Jones

 

[Statistician]

Thanks for responding guys.

Steve....thanks but already tried that and it doesn't prevent the dialog boxes from turning up.

Jo, thanks for responding. Yes I am using saveas.

Cheers

Dee