Closing Tiff file using VBA


New Member
Feb 19, 2010

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.:cool:

Some videos you may like

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.


New Member
Apr 29, 2013
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!

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Latest member

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...