I inadvertently left out the MS MODI doc URL.
http://support.microsoft.com/default.aspx?scid=kb;en-us;311765
While I would suggest you read the entire KB article here is the relvant
info.
Open takes either a qualified file path or a URL to a file on a remote Web
server. The control attempts to gain write access to the file and keep it
locked for editing unless you pass True for the ReadOnly parameter. For
example, the following code opens a local file and keeps a lock on it for
editing:
DsoFramer1.Open "C:\TestBook.xls"
If you want to open a file that is not associated with an Office
application but that can be loaded with Office, you can specify an alternate
ProgId in the Open method. For example, to open a plain text file in Word,
you can use code that resembles the following:
DsoFramer1.Open "C:\Plain.txt", , "Word.Document"
If you combine this ability with a URL, you can use code that resembles
the following to open the resulting HTML streamed back from an ASP file and
have it display as data inside of Excel:
DsoFramer1.Open "
https://secureserver/test/mytest.asp?id=123", True, _
"Excel.Sheet", "MyUserAccount", "MyPassword"
--
HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.