VBA: Print to TIFF

[OU_Guy]

Greeting Experts:

Anyone have suggestions on how to print to TIFF using VBA?

[dcrake]

What is it that you want to print to a TIFF type file?

David

[OU_Guy]

What is it that you want to print to a TIFF type file?

It's a report that I need as a TIFF type for PowerPoint. I hope that helps.

[dcrake]

Are you trying to embedd an Access report into a PP presentation? If so, I am sure there are other formats, such as PDF that will work.

David

[OU_Guy]

I need a TIFF file created so that it can be embedded to PowerPoint automatically. The goal would be to be able to push a button for this process.

Yes, the PDF solution does work but I need an automated solution.

[OU_Guy]

I tried to use the MODI reference, but I'm getting an IO error. Can anyone help? I'm trying to use MODI to print the current report to TIFF

        DoCmd.OpenReport sPage, acPreview
  
  
  Dim miDoc As MODI.Document
  
  Set miDoc = New MODI.Document
  miDoc.Create "c:\test.tif"
  
  miDoc.PrintOut 2, 2, 1, "MyPrinter"
  
  Set miDoc = Nothing