Navigate web dialog from Access and execute file Save

is it because the sendkeys would effect the IE standard page not the open/save dialog which is opened as modal?

Maybe there is some way to handle the modal dialogue form...?

I don't know how, but perhaps there is some other way... if its just opening the webpage to save...could you use ftp to connect to the server and collect the file instead?  or some way to "GET" the http page rather thna browse and save it?

ooh ooh, check this out:  thee is an API call to make get IE to save a webpage

http://www.xtremevbtalk.com/showthread.php?t=16955

IE.ExecWB OLECMDID_SAVEAS, LECMDEXECOPT_DODEFAULT

hope this helps...

i'd need to know the value o strLocation in order to try and test it for you.

Thanks for the suggestion. I'll look into it this morning. But just to be clear, I'm not trying to save a web page, I'm trying to downlaod a text document. I can't provide the link because the txt file is confidential. To help communicate this, I am attaching a screen capture. I entered the URL from my home page (google) and you see the dialog that pops up while the web page is loading. My browser never navigates away from Google, it just presents the dialog and I can save the file.

Might be easier to see if you can get it from an ftp server from the provider....

then you can use shell to call a batch file to ftp the file to a local area... then link to is or import it using access VBA automation...

batch file says:
ftp -n -s:ftp.txt

ftp.txt contains:
open <server name>
user
<username>
<password>
prompt
mget *.csv (<filename> or wildcard)
quit

depends if your provider will let you ftp...

if there is no password on the file... can you try to link to it using access or excel as a linked table? presumably once you have logged in to the client area?

did some research borrowed this from http://www.mrexcel.com/forum/showthread.php?t=67123 - this dude knows his stuff:

Colo
MrExcel MVP

this is in a form under a button:

see attached mdb for sample i converted his code to remove excel references and to run in access...maybe you can change the url to your file....

if you need to login to the website first it might pose a problem...

Option Compare Database
Private Declare Function URLDownloadToFile Lib "urlmon" Alias _
  "URLDownloadToFileA" (ByVal pCaller As Long, ByVal szURL As String, ByVal _
    szFileName As String, ByVal dwReserved As Long, ByVal lpfnCB As Long) As Long
  
Private Sub Command0_Click()
DownloadFilefromWeb
End Sub
 
 
Sub DownloadFilefromWeb()
    Dim strSavePath As String
    Dim URL As String, ext As String
    Dim buf, ret As Long
    URL = "http://chaoticage.com/age_51.shtml"
    buf = Split(URL, ".")
    ext = buf(UBound(buf))
    strSavePath = "C:\" & "DownloadedFile." & ext
    ret = URLDownloadToFile(0, URL, strSavePath, 0, 0)
    If ret = 0 Then
        MsgBox "Download has been succeed!"
    Else
        MsgBox "Error"
    End If
End Sub

                                              

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:

Sudonim,

What this code does is download the shtml document. It navigates to "http://chaoticage.com/age_51.shtml" and saves this web page as "DownloadedFile.shtml". The URL I am using is not a link to an html document. It is a link that executes an asp script that presents the user with the Save dialog to download a specific txt file. The URL does not end in ".htm" or ".html" or ".shtml". It ends in "-08C7CC2383B58299". At this point, I do not know if I can get access to this file via ftp from the vendor. I am just working with what my internal customer has given me to work with. So I am hoping to find a way to interact with the form that opens from the URL. Is there a better zone for this question?

then no.  

If you had explained the asp on-the-fly aspect in the first place i would not have wasted both our time trying to find solutions to your problem.

I edited the code to pull down the shtml file, it would work equally with a csv/xls/html/txt etc file on a web server... or any file type, and save it whever you want.

i do not think its possible to do what you want as it stands...I certainly do not know of a way to take control of the file save dialogue box which IE calls when it tries to save the file.

If the vendor can change the asp routine to create a file on the server then you can use the above to collect the created file.

Hopefully someone will come along who can find a way to automate the click to save in the dialog.

Sudonim, thanks for all of your effort. I apologize that I did not explain the situation very well. I thought I had made it clear that I was not trying to save the web page, but trying to interact with the file download dialog. In my original question I said "If I click on this URL, IE opens and an Open/Save/Cancel dialog displays." And in my first follow up, I said "But just to be clear, I'm not trying to save a web page, I'm trying to downlaod a text document." then provided screenshots that illustrate how the browser does not open to a web page but only presents the dialog. I hate that you wasted your time.

I've spent a good deal of time with the last link you provided. I'm getting closer. This link has also been helpful: http://vba-corner.livejournal.com/4623.html.  I've been able to get sendkeys to work, but not reliably. Anyway, I'll close this for now and when I get a little closer I may revise the question.