Kevin

<div>
<div class="content wysiwyg-content">
I have an Excel 2019 spreadsheet macro that has some VBA in it. &nbsp;Ideally what I would like is <br />
<br />

<ol type="1">
<li>for a user to right-click a file in Windows Explorer (Windows 10) and select &quot;Send to&quot; and have the Spreadsheet available from the &quot;Send to&quot; menu. &nbsp;Then, when the spreadsheet opens, it gets the name of the file and Autoruns using that file name in the VBA code</li>
<li>Or, if the spreadsheet is opened without the &quot;Send to&quot; method, it will not autorun</li>
</ol>
<br />
Is this possible, and if so, please help...
</div>
</div>


I have an Excel 2019 spreadsheet macro that has some VBA in it.  Ideally what I would like is 

for a user to right-click a file in Windows Explorer (Windows 10) and select "Send to" and have the Spreadsheet available from the "Send to" menu.  Then, when the spreadsheet opens, it gets the name of the file and Autoruns using that file name in the VBA code
Or, if the spreadsheet is opened without the "Send to" method, it will not autorun


Is this possible, and if so, please help...

Open an Excel file using &quot;Send To&quot; in File Exporer and passing along file name

This topic area includes legacy versions of Windows prior to Windows 2000: Windows 3/3.1, Windows 95 and Windows 98, plus any other Windows-related versions including Windows Mobile.

Windows OS

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.

Open an Excel file using &quot;Send To&quot; in File Exporer and passing along file name

Open an Excel file using "Send To" in File Exporer and passing along file name