Wow - it works!
After saying it seemed relatively simple, when I looked at the task
initially I thought this was all too much for a relative beginner. I fell
at the first hurdle when the calling sub does:
Dim objHTTP As InetTransferLib.HTTP
There was no InetTransferLib object of course. Then I realised the Library
code needed to be in a Class Module and it all fell into place!
(Shame about the pop-up, but I understand the logic and etiquette.)
Thank you very much Doug (and to Dev Ashish and Terry Kreft or course).
Regards,
Robin
"Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
news:(E-Mail Removed)...
> You could always simply include the necessary code from the add-in as a
> module in your application.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
> "Robin" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Ok, many thanks Doug.
>>
>> I've been wondering if there might be a COM alternative that doesn't need
> an
>> add-in, such as using Excel as an intermediary to open the remote file
>> and
>> save it locally, or possibly use of DDE to extract the file content from
>> Excel. I need to do some investigation.
>>
>> Regards,
>>
>> Robin
>>
>>
>> "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
>> news:(E-Mail Removed)...
>> > The add-in would need to be added for each user.
>> >
>> > --
>> > Doug Steele, Microsoft Access MVP
>> > http://I.Am/DougSteele
>> > (no e-mails, please!)
>> >
>> >
>> > "Robin" <(E-Mail Removed)> wrote in message
>> > news:(E-Mail Removed)...
>> >> Thanks Alex.
>> >>
>> >> The code (and your suggestion to download to a local drive) makes
> perfect
>> >> sense - the API addin, I'm less sure about just through my lack of
>> >> knowledge.
>> >>
>> >> Once imported, does the addin remain embedded in the application on
>> >> distribution or would this need to be added for each user? If it
>> >> needs
>> >> to
>> >> be added for each user I might need to seek an alternative solution.
>> >>
>> >> Thanks again,
>> >>
>> >> Robin
>> >>
>> >>
>> >> "Alex Dybenko" <(E-Mail Removed)> wrote in message
>> >> news:(E-Mail Removed)...
>> >> > Hi,
>> >> > suggest that you first download excel file using this API:
>> >> > http://www.mvps.org/access/modules/mdl0037.htm
>> >> > and then import it from local drive
>> >> >
>> >> > --
>> >> > Best regards,
>> >> > ___________
>> >> > Alex Dybenko (MVP)
>> >> > http://alexdyb.blogspot.com
>> >> > http://www.PointLtd.com
>> >> >
>> >> > "Robin" <(E-Mail Removed)> wrote in message
>> >> > news:(E-Mail Removed)...
>> >> >> Hi
>> >> >>
>> >> >> I'm developing an Access App which pulls data from various sources
> and
>> >> >> compiles summary reports. Some of the data sources are Excel files
> on
>> >> >> network folders and I can use "DoCmd.TransferSpreadsheet acImport"
> to
>> >> >> import these to a table. However, some of the sources are Excel
> files
>> > on
>> >> >> internal SharePoint sites, and have an http://.... address.
>> >> >>
>> >> >> Is there a VBA method for importing data over http? I've obviously
>> > tried
>> >> >> "DoCmd.TransferSpreadsheet acImport" but this generates an error:
>> > 3651 -
>> >> >> invalid internet address.
>> >> >>
>> >> >> Many thanks
>> >> >>
>> >> >> Robin
>> >> >>
>> >> >
>> >>
>> >>
>> >
>> >
>>
>>
>
>
Similar Threads
