<div>
Yes, my DownloadFile function here:<br />
<br />
<a href="https://www.experts-exchange.com/articles/29679/Show-pictures-directly-from-URLs-in-Access-forms-and-reports.html" rel="ugc">Show pictures directly from URLs in Access forms and reports</a><br />
<br />
but when you tell that it downloads the html file (the page), it tells me that you don't use the URL for the file itself (the pdf).<br />
So, how is your URL looking, please?
</div>


<div>
Hi Gustav - it's been a while - hope you are well.<br />
<br />
Here is a link to the test file. &nbsp;I ultimately want to download this file to D:\fenix3_OM_EN.pdf<br />
<br />
<a href="https://www.dropbox.com/s/3t70keflzd9nsce/fenix3_OM_EN.pdf?dl=0" rel="ugc">https://www.dropbox.com/s/3t70keflzd9nsce/fenix3_OM_EN.pdf?dl=0</a>
</div>


Developer

Andy Brown

<div>
Thanks Gustav - I went onto the Developers area, looked at the HTTP settings and discovered that if you replace =0 at the end with =1, then it downloads it (rather than open it).<br />
<br />
<a href="https://www.dropbox.com/s/3t70keflzd9nsce/fenix3_OM_EN.pdf?dl=1" rel="ugc">https://www.dropbox.com/s/3t70keflzd9nsce/fenix3_OM_EN.pdf?dl=1</a>
</div>


<div>
Hmm. That was my first thought: dl = download, and 0 = False, thus try 1 for True.<br />
But it didn't work for me. Or so it seemed.<br />
<br />
I tried again, and right, it works.
</div>


<div>
<div class="content wysiwyg-content">
I have a Microsoft Access application running on an RDP server that is heavily locked down. &nbsp;I need to give users the ability to download files from a link (such as Dropbox), which can then be processed by the application (Excel for importing, PDF for email attachments etc). &nbsp; <br />
<br />
I have created a form that allows users to enter the link and found a couple of code snippets that in theory handle the download (using URLDownloadToFile and the Microsoft.XMLHTTP object). &nbsp;However, whilst it does generate a file - it's an HTML file (not the PDF test file I was hoping for)<br />
<br />
Does anyone know of a reliable way of downloading the actual file?
</div>
</div>


I have a Microsoft Access application running on an RDP server that is heavily locked down.  I need to give users the ability to download files from a link (such as Dropbox), which can then be processed by the application (Excel for importing, PDF for email attachments etc).   

I have created a form that allows users to enter the link and found a couple of code snippets that in theory handle the download (using URLDownloadToFile and the Microsoft.XMLHTTP object).  However, whilst it does generate a file - it's an HTML file (not the PDF test file I was hoping for)

Does anyone know of a reliable way of downloading the actual file?

VBA / Download file from the web.

HTML (HyperText Markup Language) is the main markup language for creating web pages and other information to be displayed in a web browser, providing both the structure and content for what is sent from a web server through the use of tags. The current implementation of the HTML specification is HTML5.

HTML

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.