View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
marcus. marcus. is offline
external usenet poster
 
Posts: 1
Default 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