• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 138
  • Last Modified:

printing to printer and file

Basically I have a form with lots of data that I created a sub to print in a neat way to a printer using the printer object

now I also need to send that data to a file to be viewed.

what is the best way to do this?
0
Marv-in
Asked:
Marv-in
1 Solution
 
Steve SiricaSenior Web Application EngineerCommented:
You could try something simple like:
    Dim fso         As New FileSystemObject
    Dim fsoTS       As TextStream

    Set fsoTS = fso.CreateTextFile(sFileName, True)
   
    fsoTS.WriteLine String("Put output data here")

    If Not fsoTS Is Nothing Then
        fsoTS.Close
    End If
    Set fso = Nothing
   
0
 
Marv-inAuthor Commented:
This is a bit more involved - there are graphs and lines - an image or pdf file would work best.
0
 
Steve SiricaSenior Web Application EngineerCommented:
Not for free is ain't.  I'm out!
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
SethiCommented:
Probably a free PDF control will help:
PDF Creator: http://sourceforge.net/projects/pdfcreator/
0
 
vinnyd79Commented:
How about capturing the form,then saving as a picture:

http://support.microsoft.com/default.aspx?scid=kb;en-us;161299
0
 
Marv-inAuthor Commented:
vinnyd79 - that would work but the info and grapsh are spread across many tabs
Sethi - that is an excelent option, althought i dont have the time to dive into this now - ill give you the point because this would work if i had time.

i did find another solution - i found that my company has purchased active reports 2 from data dynamics so i will use that.

Thanks
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now