Download a file automatically from app.box.com link.

[bigroo1958]

Hi All,
I am looking for a way to automatically download are file from app.box.com. I have being trying using excel VBA code; I usually get an email saying there is a new version available. I can get vba to automatically select the latest email in an outlook folder, to get the web address from within the email and from there to open the web page. That's as far as I can get with my knowledge. Has anyone any clues or perhaps another way of doing it? I want to download the file from the link to a folder on my hard drive.

It may be of course, that such drop-boxes are designed to stop this kind of interaction.

[bigroo1958]

Bump this message

[bigroo1958]

Any takers on this message?

Here is the code I am using.

Sub IE_Refresh2()

Dim URL As String
Dim IE As SHDocVw.InternetExplorer
Dim HTMLdoc As HTMLDocument
Dim refreshLink As HTMLLinkElement
Dim i As Integer

URL = "https://app.box.com/s/2hnt5hlk17xofi3bfn2q"

Set IE = New SHDocVw.InternetExplorer

With IE
.Visible = True
.Navigate URL
While .Busy Or .readyState <> READYSTATE_COMPLETE: DoEvents: Wend
Set HTMLdoc = .Document
End With

'Get the Refresh link

Set refreshLink = Nothing
i = 0
While i < HTMLdoc.Links.Length And refreshLink Is Nothing
If HTMLdoc.Links(i).innerText = "Refresh" Then Set refreshLink = HTMLdoc.Links(i)
i = i + 1
Wend

If Not refreshLink Is Nothing Then

'Click Refresh and wait for it to finish

refreshLink.Focus
refreshLink.Click
Do
DoEvents
'Sleep 200
Loop Until refreshLink.parentElement Is Nothing

MsgBox "Done"
End If

End Sub

Any assistance would be appreciated, or perhaps another way of doing, so I can download the file to my computer?

Thanks

[bigroo1958]

Bump back into the list.
Anyone have an idea how to do this?