[AccessD] Downloading Web File Automatically

GE uses this thing called single sign on and you Have to hit that landing
page to (aftet loging in) have the url revert to your destination url.

...grabled by smrat phonn as ususl
On Nov 19, 2012 8:21 PM, "Stuart McLachlan" <stuart at lexacorp.com.pg> wrote:

> It depends on the site. If the site is using basic HTTP authentication,
> you can use
> http://userid:password@www.example.com/
>
> If the page uses PHP, JScript or whatever to prompt for a password, that
> won't work.
>
> --
> Stuart
>
> On 20 Nov 2012 at 13:59, David Emerson wrote:
>
> > I was able to include the login and password in the url and the file
> > downloads no problem.
> >
> > David
> >
> > -----Original Message-----
> > From: accessd-bounces at databaseadvisors.com
> > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William
> Benson
> > Sent: Tuesday, 20 November 2012 1:02 p.m.
> > To: Access Developers discussion and problem solving
> > Subject: Re: [AccessD] Downloading Web File Automatically
> >
> > Hi guys / gals what happens if there is a security check in the mean time
> > requiring login with usermame (SSO, e.g.) and password? does the code
> below
> > break or just wait patiently?
> >
> > ...grabled by smrat phonn as ususl
> > On Nov 14, 2012 5:05 PM, "Stuart McLachlan" <stuart at lexacorp.com.pg>
> wrote:
> >
> > > Even better - A way to automate this in Access which doesn't need to
> > > invole a browser.
> > >
> > >
> > > 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
> > >
> > >
> > > Public Function DownloadFile(URL As String, LocalFilename As String)
> > > As Boolean Dim lngRetVal As Long lngRetVal = URLDownloadToFile(0, URL,
> > > LocalFilename, 0, 0) If lngRetVal = 0 Then DownloadFile = True End
> > > Function
> > >
> > > --
> > > Stuart
> > >
> > >
> > > On 15 Nov 2012 at 9:40, David Emerson wrote:
> > >
> > > > Team,
> > > >
> > > > I have an application that imports a csv file.  The file is put up
> > > > onto a web site url.  Entering the url in a browser will trigger
> > > > downloading the file.
> > > >
> > > > Is there a way to automate this in Access.  Ie send the url to a
> > > > browser, have the file downloaded to a defined folder where it can
> > > > then be
> > > imported?
> > > >
> > >
> > > --
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > http://databaseadvisors.com/mailman/listinfo/accessd
> > > Website: http://www.databaseadvisors.com
> > >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>