Closing Tiff file using VBA

[Prabhu_Bob]

Hi,

Can any one help me on this.

I have created a macro to print tiff files (Microsoft office imaging writer). I have given the print in a loop so that report if generated for all of my staffs.

Since i am printing for more numbers the code is interrupted because of the files remaining in open status.

If i wanted to correct it i needed the close command for closing the tiff files immediately after generating. I need to control image writer using excel Macros.

I hope some one can help me on this.

 

[sai85]

Have you solved this? Even I am also in Same problem. Please share code for printing in Tiff Format and as well as closing tiff. Thanks in advance!