Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Net Send in NT - VBA'able in MSAccess 97? 1

Status
Not open for further replies.

jwkolker

Programmer
Jan 9, 2003
68
US
Hello:

Is there a way to VBA script this .bat file instead of calling the bat file from access 97?

net send jkolker Test of Warning - Please Release Reporting System for Back up...John Kolker - 30786
rem net send phogg Test of Warning - Please Release Reporting System for Back up...John Kolker - 30786
rem net send mkatz Test of Warning - Please Release Reporting System for Back up...John Kolker - 30786
rem net send jconsentino Test of Warning - Please Release Reporting System for Back up...John Kolker - 30786
rem net send ctroup Test of Warning - Please Release Reporting System for Back up...John Kolker - 30786
rem net send scook Test of Warning - Please Release Reporting System for Back up...John Kolker - 30786
rem net send ichilvers Test of Warning - Please Release Reporting System for Back up...John Kolker - 30786
exit

If I have to call the .bat file what is the VBA to do so?

Regards,

John Kolker
Programmer
jwkolker@comcast.net

John Kolker
Programmer
jwkolker@comcast.net
 
Hi John,

You don't need to call the batch file.
Simply use the following :
Sub NetSend()
Shell ("net send recipient message")
End Sub

Regards,

Assad.
 
Assad

Thank you very much! It works well.

JK John Kolker
Programmer
jwkolker@comcast.net
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top