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.
http://www.outlookcode.com/article.aspx?id=69