Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 399
  • Last Modified:

OpenURL method

Hi I found a way to retrieve binary file from URL with this method in vb but I can't find the way to use it in access.
Someone can help me, give me an example?


http://support.microsoft.com:80/support/kb/articles/Q163/6/53.ASP&NoWebContent=1
0
meciab
Asked:
meciab
  • 2
1 Solution
 
svenkarlsenCommented:
Hi mecia,

first of all: you are aware that this is just usning a form in Access to do what you can much better do with Internet Explorer ? I.e.: this is not a 'function' it is an ActiveX object that you put on a form, and then click a button for operation.

If I am right in assuming that you want to do FTP from code, I suggest you have a look here instead:

 > http://www.vbip.com/winsock/index.asp

This is a really good source and explains everything, including some of the stuff that Microsoft doesn't document!

Kind regards,
Sven
0
 
meciabAuthor Commented:
No I just want to use this function in access, but i cannot find the way to reference OpenUrl method.

Function test()
Dim b() As Byte
Dim strURL As String
Dim SavPath As String

strURL = "http://experts-exchange.com/images/logo.gif"
SavPath = "c:\"

    b() = Inet1.OpenURL(strURL, icByteArray)
    'Write the image to a local file:
    Open SavPath & "test.jpg" For Binary Access _
    Write As #1
    Put #1, , b()
    Close #1

end function
0
 
meciabAuthor Commented:
Yopssssss.....
I found the answer to my question the reference to add is MSinet.ocx (Microsoft Internet Tranfer Control)
Thanks for your help
0
 
Computer101Commented:
PAQed, with points refunded (500)

Computer101
E-E Admin
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now