in reply to (OT) Excel reading problem

[excel button], [excel format], [ddg://site:perlmonks.org excel button], [ddg://site:perlmonks.org exc +el format]
excel button, excel format, site:perlmonks.org excel button, site:perlmonks.org excel format, site:perlmonks.org excel save-as prompt alert button, site:perlmonks.org excel save-as format prompt alert ... $Excel->{DisplayAlerts}=0;

saveas ... and see the relevant documentation on msdn )

Replies are listed 'Best First'.
Re^2: (OT) Excel reading problem
by merrymonk (Hermit) on Sep 17, 2014 at 15:12 UTC
    The display alerts worked so that setting it to 0 before opening the file and then to 1 after all had been done, I no longer got the error message.

    The actual line that caused the message seems to be

    $workbook->Close;
    which makes sense to me.

    Thank you.