Hello, I need to open a .tif file and print it out, then close the file using VBScript. I am new at scripting and I do not have a book and I cannot find this anywhere on the web. Thanks!

As far as opening the file you could use the ShellExecute function. The ShellExecute function will have to be declared as follows Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" _ (ByVal hwnd As Long, _ ByVal lpOperation As String, _ ByVal lpFile As String, _ ByVal lpParameters As String, _ ByVal lpDirectory As String, _ ByVal nShowCmd As Long) _ As Long Then you can call the ShellExecute function in your macro by doing something like this dim someVariable someVariable = ShellExecute(0&, vbNullString, Environ("USERPROFILE") + "\My Documents\myTiffFile.tif", vbNullString, vbNullString, vbNormalFocus) More info on ShellExecute can be found here http://msdn.microsoft.com/library/d...

Thanks, I used set shell = createobject("WScript.shell") shell.Run ("mspaint /pt "filepath" "printer name")