in reply to Suppressing dialog boxes in Win32::OLE, InternetExplorer, and Excel

Well, I solved my own problem.

In case anyone else encounters a similar issue, all I had to do was call

$doc->{'Saved'} = 1;

after calling SaveAs.

I don't know why calling SaveAs didn't set Saved, nor do I understand why turning DisplayAlerts off didn't suppress the dialog box, but setting Saved did work.

  • Comment on Re: Suppressing dialog boxes in Win32::OLE, InternetExplorer, and Excel
  • Download Code