Print *.tif image file from vba excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top