I guess that would mean you using ADO.

If your using ADO, then you don't start the excel application and you should
not get any prompts except for errors.

--
Regards,
Tom Ogilvy

"Lew" wrote in message
...
Guess I didn't say enough. The data is being pulled out by my VFP code
into corporate data stores. This allows us to have a single platform for
pulling from a large variety of sources ... (text, word, excel, ftp stuff,
etc...)
-Lew
"Tom Ogilvy" wrote in message
...
If you are using the clipboard and have a large amount of data, when you
attempt to close the file you could get a prompt to retain the
information in the clipboard.

You can suppress this with DisplayAlerts or you can copy an individual
cell to the clipboard before closing the workbook.

--
Regards,
Tom Ogilvy


"Lew" wrote in message
...
I'm writing an automation project which involves extracting data from
ss
we receive from a bewildering number of sources, and we're afraid of the
possibility that my app may trigger a malicious macro. I understand that
I've got to set the AutomationSecurity value to 3, but I've still got a
few
questions.
First: The tools-macros-security tab has 4 values; why can I only
set
the AutomationSecurity value to 1, 2 or 3 (ie only 3 possible values)?
Second: If I set AutomationSecurity to 3 and, since we plan to
disable
user interaction with excel while my app is running by making excel
invisible, is there any possibility that a macro (or anything else)
could
trigger a dialog requiring user input & resulting in an apparent hang?
If
yes, will DisplayAlerts = false take care of this? Please bear in mind
that
the only thing we're doing (as of now anyway) is pulling values out of
cells, not anything that I see as requiring interaction.
Other suggestions or things to watch out for?
TIA!



--
-Lew
The workers took the robot for Maria.