FollowHyperlink to file in DropBox??? I need HELP!

[ma t]

Hello- I am trying to use followhyperlink as a way to open a link in a browser to a file in a shared dropbox folder. I have a form with a control, the control is named LinkToDoc it's record source is a text field in a table. The file path in the table is similar to https://www.dropbox.com/s/7u88x58dbi...ral_FID69.docx. I am getting run time error 15, cannot open the specified file. Does anyone know if this is possible? Thank you very much in advance!

Private Sub cmdOpenFile_Click()
Application.FollowHyperlink LinktoDoc
End Sub

[June7]

I have doubts FollowHyperlink can do this.

If Dropbox is anything like loading a file to Box.com (I use that fileshare site), what might have to do is download file to local drive then open the local copy. When finished editing, upload the file back to the shared folder.

I expect VBA code that manipulates IE browser could accomplish the down and up loading steps.

[ma t]

Thank you, June7, any idea where I can get that code? Many thanks,

[June7]

The most I've ever done is open IE browser and pass in some values to boxes on web page. How to automate down and up loading is unknown to me.

My code:

Dim oBrowser As InternetExplorer
Set oBrowser = New InternetExplorer
oBrowser.Silent = True
oBrowser.Navigate "https://login.ihserc.com/login/erc?"
oBrowser.Visible = True
Do
'Wait till the Browser is loaded
Loop Until oBrowser.ReadyState = READYSTATE_COMPLETE
oBrowser.Document.all.Item("subAcctLoginName").Val ue = "login name"
oBrowser.Document.all.Item("subAcctPassword").Valu e = "password"
oBrowser.Document.all.Item("Submit").Click

Google: VBA download upload file web page
Does this help http://www.cpearson.com/Excel/DownloadFile.aspx