kamur
asked on
Sending Net Messages using VBA
Hello,
Our team uses Win2000 machines and lets say we all are in domain name, Domain1. Lets say there are 2 share drives, we all use...D:\ and S:\. I have kept an excel sheet on S:\Team\Update.xls.
What I need is:
Whenever any member of the team, updates this xls (that is, Saves this xls), I want some kind of notification to be sent to a log file which is present in D:\logfile.txt. The notification should have the following details:
LanId of the person saving xls, Name if possible of the person, Date and time of the Save and the name of the workbook he/she has saved. (There are multiple workbooks on the drive). I want the logfile to be appended everytime someone Saves the list of xls present in the Team folder under S:\ drive.
Also, along with this, it would be great if the VBA can send a NET SEND Message to my machine as well as an when someone saves the xls's.
Any ideas how I can achieve this using Excel VBA?
Regards
Our team uses Win2000 machines and lets say we all are in domain name, Domain1. Lets say there are 2 share drives, we all use...D:\ and S:\. I have kept an excel sheet on S:\Team\Update.xls.
What I need is:
Whenever any member of the team, updates this xls (that is, Saves this xls), I want some kind of notification to be sent to a log file which is present in D:\logfile.txt. The notification should have the following details:
LanId of the person saving xls, Name if possible of the person, Date and time of the Save and the name of the workbook he/she has saved. (There are multiple workbooks on the drive). I want the logfile to be appended everytime someone Saves the list of xls present in the Team folder under S:\ drive.
Also, along with this, it would be great if the VBA can send a NET SEND Message to my machine as well as an when someone saves the xls's.
Any ideas how I can achieve this using Excel VBA?
Regards
ASKER CERTIFIED SOLUTION
![Avatar of [ fanpages ]](https://filedb.experts-exchange.com/files/public/2020/2/28/4acbe344-900b-4e79-96ce-65fe58a6f004.png){kind=small}
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
What I meant was Net Send to my machine only.....Any just wondering...if I need multiple persons, I could just repeat the statement multiple times, right?
Anyway, thanks for all the help on this question..!
Regards