Run macro from email
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 |
All times are GMT +1. The time now is 10:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com