Print *.tif image file from vba excel
I wish to print a tif image file from vba excel... how do i do this???
The whole program is runs a search based on criteria in an excel spreadsheet for tif image files and then wish to print them... how do I print the files found from excel? Inputs to the below code are 'MyConnote' = 10000232 (for example)..
With Application.FileSearc
.NewSearc
.LookIn = "C:\My Documents
.SearchSubFolders = Tru
.FileName = MyConnote & "*.tif
.FileType = msoFileTypeAllFile
If .Execute() The
For i = 1 To .FoundFiles.Coun
' WISH TO PRINT IMAGE FILE (TIF
Next
End I
End Wit
|