Avatar of Kevin
Kevin
Flag for United States of America asked on

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

I have an Excel 2019 spreadsheet macro that has some VBA in it.  Ideally what I would like is

  1. 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
  2. Or, if the spreadsheet is opened without the "Send to" method, it will not autorun

Is this possible, and if so, please help...
Windows OSVBAMicrosoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Kevin

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Alptekin Keskin

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
Fabrice Lambert

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Kevin

ASKER
Thank you both!
Your help has saved me hundreds of hours of internet surfing.
fblack61