Hi.
I've created an application which registers employees comments in the
database. After user enters a comment, an email is sent to everyone
interested. The email is filled with some details about the comment,
including a link to a network location, where the comments xlsm file
is located.

My question is, if it's possible to prepare this link to run the code
from this file with a parameter?

From excel to excel I can use:
Application.Run "\\server\folder\comments.xlsm!CommentsForm", 12345
where 12345 is a parameter.

How to do that in email (HTML format)? Now I'm creating a normal
hyperlink:
<a href="\\server\folder\comments.xlsm"Show comments</a
but it's only opening a file.

I was thinking about Workbook_Open event - but still I need to pass
the parameter somehow.

Any advice?

Thanks,
Kamil