Hi,

I'm trying to save a series of web pages as text files using Excel and
Internet Explorer without getting a
dialogue box. The execCommand supposedly allows you to do this by setting
the parameter bUserInterface to false. I've tried this but it doesn't work -
I always get the dialogue box! Can anyone help? The code being used is

oIE.Document.execCommand "SaveAs", false, mytextfile

where oIE is my internet explorer object and mytextfile is a string variable
with the name of the file. It picks up the variable mytextfile, so all I
have to do is press enter to save the required file. Obviously I don't want
to do this 1000s of times for the pages I'm saving.

Parameters for the execCommand are

sCommand : string specifying command to execute
bUserInterface: Boolean - true = dialogue box, false = no dialogue box,
provided vValue parameter exists.
vValue: specifies file name to save.

I'd be most grateful for any help
Many thanks
Oliver

--
---------------------------------------------------------
Dr R. Oliver Hill
64 {*filter*}Lane
Milton
Cambridge
CB4 6DG
UNITED KINGDOM

Tel. +44 (0)1223 44-1519
Mobile. +44 (0) 795 666-6588

If you are the server and client at the same time.
Not the same machine or intranet network.

No one is supposed to 'programmatically' harddrive [to do] data via a
browser.

Cookies and so on the spoil.

If you or anyone else

(not) interfacing anything (e.g. a dialog)

were true,

all'd be chaos.

------

Dualims:

Good    Bad
Client    Server

It takes two to tango