Avatar of Joe5
Joe5
 asked on

Custom Outlook button to activate Excel and select a cell

I am no expert on Outlook and what is possible there, so bear with me (am familiar with Excel VBA though).

Is it possible to create a custom button somewhere in Outlook that when clicked will bring Excel to front and select a certain cell?  The button could be accessible from within an Appointment window, or from the Outlook calendar view, or from both (which would be very nice).

The subject of the Outlook Appointment would be for example "XYZ123", and the Value of one of the cells in column A in the Excel sheet too would be "XYZ123" - and that is the cell I would like selected.  (If the button is in the Outlook calendar view, assume the relevant Appointment is highlighted/selected or whatever the term is.)

If this can even be done, I have no idea how much code it will take, hence partial answers too will be much appreciated.
OutlookVisual Basic Classic

Avatar of undefined
Last Comment
David Lee

8/22/2022 - Mon
puppydogbuddy

See instructions and code at this link:
         http://www.outlookcode.com/article.aspx?id=69
ASKER CERTIFIED SOLUTION
David Lee

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.
Joe5

ASKER
WOW!  I am so impressed by this - I never thought I would get a spot on solution with complete and working code..... simply amazing.  Boy am I glad I posted this question!  Thank you!!!
Joe5

ASKER
puppydogbuddy: the link describes how to create an Outlook form with Excel functionality (as far as I can tell) - interesting but not quite what I was looking for, it seems.

For anyone interested, regarding the code of the accepted solution, I used GetObject in stead of  CreateObject to grab an already open instance of Excel.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
David Lee

You're welcome!  I'm happy I was able to help out.  Cheers!