ouestque

<div>
<div class="content wysiwyg-content">
What VBA would I use that would download a file, but before doing so validate the file can be downloaded before attempting the pull. If possible please try to do this without using On ERROR. I'm trying to see if there is a solid way to check if a file can be downloaded without attempting the download first.<br />
<br />
EXAMPLE<br />

<ul>
<li>Assume we are downloading the file at the following link: <a href="https://data.cdc.gov/api/views/cjae-szjv/rows.csv?accessType=DOWNLOAD" rel="ugc">https://data.cdc.gov/api/views/cjae-szjv/rows.csv?accessType=DOWNLOAD</a></li>
</ul>
<ul>
<li>In the link above it would validate the file can be downloaded before attempting the download. If for any reason the file could not be downloaded a message box would appear stating &quot;The file can not be pulled. The link may have changed.&quot;</li>
</ul>
<br />
EXTRA NOTES<br />

<ul>
<li> I may have seen someone try to do this using Dos/Shell but couldn't get it to work at the time and don't remember where it is at.</li>
</ul>
</div>
</div>


What VBA would I use that would download a file, but before doing so validate the file can be downloaded before attempting the pull. If possible please try to do this without using On ERROR. I'm trying to see if there is a solid way to check if a file can be downloaded without attempting the download first.

EXAMPLE
Assume we are downloading the file at the following link: https://data.cdc.gov/api/views/cjae-szjv/rows.csv?accessType=DOWNLOAD

In the link above it would validate the file can be downloaded before attempting the download. If for any reason the file could not be downloaded a message box would appear stating "The file can not be pulled. The link may have changed."


EXTRA NOTES
 I may have seen someone try to do this using Dos/Shell but couldn't get it to work at the time and don't remember where it is at.


Excel VBA: Validate File Can Be Downloaded

The term 'shell' refers to a general class of text-based command interpreters most often associated with the UNIX and Linux operating systems. Popular shells include Bourne, Debian Almquist (dash), Korn (ksh), Bourne Again (bash) and the C shell family (csh). Some view the DOS 'cmd' prompt as a minimal shell of sorts. It is also possible to install Cygwin on Windows and emulate a full Unix environment with complete shell capabilities. Terminal emulators, such as xterm, GNOME Terminal and OS X Terminal, can be used to access shell.

Shell Scripting

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.

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.