<div>
<div class="content wysiwyg-content">
For security reasons, I want to open the file, let the vba code use the contents, then close the file -- without ever saving the file to the local computer. &nbsp;I am guessing this is similar to the solution to<br />
<a href="https://www.experts-exchange.com/questions/23627204/Download-file-from-remote-ftp-site-via-VBA-Excel.html" rel="ugc">https://www.experts-exchange.com/questions/23627204/Download-file-from-remote-ftp-site-via-VBA-Excel.html</a><br />
except that I do not want to save the file locally, just open it.
</div>
</div>


For security reasons, I want to open the file, let the vba code use the contents, then close the file -- without ever saving the file to the local computer.  I am guessing this is similar to the solution to
https://www.experts-exchange.com/questions/23627204/Download-file-from-remote-ftp-site-via-VBA-Excel.html
except that I do not want to save the file locally, just open it.

How to use VBA to open a file residing on a password protected ftp server?

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.

Security is the protection of information systems from theft or damage to the hardware, the software, and the information on them, as well as from disruption or misdirection of the services they provide. The main goal of security is protecting assets, and an asset is anything of value and worthy of protection.  Information Security is a discipline of protecting information assets from threats through safeguards to achieve the objectives of confidentiality, integrity, and availability or CIA for short. On the other hand, disclosure, alteration, and disruption (DAD) compromise the security objectives.