This script displays a list of printers and asks you to enter the printer number which it then sets as the default. Note the SetDefaultPrinter method which takes the printer number. VBSTART Sub DefaultPrinter Dim Text, Title, i, j, tmp, printer Dim Network, oDevices ' Create a new Network object to ...

Contributed By: Marcus Tettmar mtettmar@mjtnet.com Submitted On: 07/08/03 To reference VBScript variables and arrays simply use the VBEval function: VBEval>VBScriptVariable,MacroScriptVariable This puts the value of the specified VBScript variable into a local MacroScript variable.  The VBScri...

Contributed By: Marcus Tettmar mtettmar@mjtnet.com Submitted On: 07/08/03 Update: It is now possible to read CSV data into a native array using the DBQuery function added in v10. See: http://www.mjtnet.com/blog/2009/03/12/reading-from-csv-files/ The code below is only necessary in earlier versions o...

Contributed By: Captive Captive@proceed.net Submitted On: 16/03/03 Rem>---------------------------------------------------------------------- Rem>' ** Macro Scheduler update checker ** v1.00 - 13/Mar/2002 Rem>' ** Written by Captive Rem>' Rem>' This script will download the file "mscver.txt" from th...

Contributed By: Marcus Tettmar mtettmar@mjtnet.com Submitted On: 21/02/03 VBSTART Sub ExcelExample Dim xlApp Dim xlBook Dim xlSheet Set xlApp = CreateObject("Excel.Application") Set xlBook = xlApp.Workbooks.Add Set xlSheet = xlBook.Worksheets(1) xlApp.visible = True 'optionally make the sheet visibl...

Hi,

I have edited Lumumba's post so that the spaces are removed from the end of the lines. Now you can copy his code again and it should work.

Please remember when posting code to press the 'Code' button or insert ... surrounding the code.

Marcus

Hi,

This is on the list for improvement in the next version.

I'm not very happy myself!!! We do perform daily backups. But it would appear the last few were corrupt. I am very sorry! It has been a very horrible day and I am extremely dissatisfied with our hosting providers and will be looking for a new co-location provider and putting better backup/restore so...

Hi, Found this site today: http://www.winscriptingsolutions.com/ It is part of Windows and .NET Magazine Network. We think Macro Scheduler is an ideal subject for this site, and will be working on getting a news article and/or review in there. To help get the attention of the editors, why not send a...

The MacroScript Command Reference installs with Macro Scheduler and you will find a link to it from your Macro Scheduler program group on your Start menu. However, you can also access the latest version online at: http://www.mjtnet.com/command_ref_7.1.pdf You will need the free Adobe Acrobat Reader ...