I am opening a number of excel files and reading ranges
from many pages and inserting them into a DB.
This all being done from VB6.
My problem is that I cannot seem to disable the warning
message and dialog prompts that surface when certain xls
files are opened.
I have tried the following lines of code with no success.
xlApp.Interactive = False
xlApp.DisplayAlerts = False
Is there another way to kill these warnings. This is a
process that runs on its own.