Closing Tiff file using VBA

Prabhu_Bob

New Member
Joined
Feb 19, 2010
Messages
19
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.:cool:
 

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

sai85

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

Watch MrExcel Video

Forum statistics

Threads
1,133,273
Messages
5,657,777
Members
418,413
Latest member
Radoslaw Poprawski

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top