Process excel files, suppress alerts
Recently however we received excel files from a new client which my
application has been unable to process. The problem is that this file has
external links and when you open the excel file, it prompts you to either
update linked information or keep exisiting information.
Try
xlsdoc.Application.DisplayAlerts = False
to address the sheet within the application.
|