![]() |
You focus on business. |
We deal with the automation. |
|
MySC sample solutions These short programs are intended to demonstrate the potential of Microsoft VBA and Windows Scripting Host. Note : After you have downloaded the sample files, please rename the file extension to .vbs e.g. from engine.txt to engine.vbs (1) Windows Scripting Host (WSH) engine setup This program will help determine if WSH is installed and activated on your system. Don't worry if it is not there because you can always download the program free from this Microsoft site. Website = Microsoft WSH download Filename = ENGINE.VBS (click to download) (2) Excel chart generator Starts Excel program automatically to create a chart using data either from Excel worksheet or from external source. Filename = CHART.VBS (click to download) (3) Sending e-mail to clients Here's how you can automatically start Outlook to create the subject and content in an e-mail message. Of course, the complete solution will send the e-mail without requiring any response from you. Filename = EMAIL.VBS (click to download) (4) Get contacts from Outlook address book If you have created some contacts in the Contacts folder, this program will read them out for you. One possible application would be to perform mail merge with Word documents. Filename = GETCONTACT.VBS (click to download)
These links contains more solutions writeup to countless Microsoft Office automation possibilites. |