ConvertReportToPDF-Leben - Repeat macro

[PJ]

Hi,

I am using Steven Leben's database to convert reports to PDF. I have the
put the ConvertReportToPDF in a macro. Then I have another macro that runs
the first macro and repeats. Each time the snapshot file is saved, it says
it already exists and asks if you want to replace it. How can I
automatically overwrite that file each time, without having to say Yes to
that question?

I have tried using sendkeys, but I think because more is done within that
line in the macro, it doesn't get to the sendkeys line until later.

 

[Steve Schapel]

PJ,

One option, I suppose, would be to use a different name for each file.

Apart from that, as far as I know there is no way to stop this message.
You could delete the file each time, but that is not possible in a
macro either, you would do that in VBA using the Kill method.