Perform specific action if workbook is opened under special circumstances

[ks100]

My VBA program allows a user to submit a ticket. The ticket gets e-mailed to me to where I can approve it.

Right now, if I want to approve a request a user submits, I have to open the VBA program, type in their ticket number, press search, and then approve it.

How can I accomplish this with a link directly from the e-mail, that would auto approve it?

I imagine I could build in a special start event in the macro that when X criteria is true, load Y ticket number and approve it, but how would I do this?

Basically I need some way in which to pass on both the ticket number and some kind of boolean that says that i'm entering the workbook for a quick approval, to the program when I open it from my e-mail.

I wrote the original program so I have complete control over it's code, as well as the link and e-mail that gets sent to me, just not sure how to convert it to one click.

[TMS]

I hope there's some money changing hands here

[ks100]

I hope there's some money changing hands here

What do you mean?

[TMS]

Sorry, my previous answer was intended for another thread. I had been looking at your thread and obviously posted here instead of elsewhere.

It's difficult to respond to your question based on the information provided. What does your code do as it stands? What do you want it to do differently?

I think you need to share the code and, ideally, a sample workbook.

This:

How can I accomplish this with a link directly from the e-mail, that would auto approve it?

sounds like you'd need an Outlook VBA Macro.

Regards, TMS