Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Custom Outlook button to activate Excel and select a cell

Avatar of Joe5
Joe5 asked on
Visual Basic ClassicOutlook
5 Comments1 Solution370 ViewsLast Modified:
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.
ASKER CERTIFIED SOLUTION
Avatar of David Lee
Commented:
This problem has been solved!
Unlock 1 Answer and 5 Comments.
See Answers