Link to home
Start Free TrialLog in
Avatar of Marv-in
Marv-in

asked on

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?
Avatar of Steve Sirica
Steve Sirica
Flag of United States of America image
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
   
Avatar of Marv-in
Marv-in

ASKER

This is a bit more involved - there are graphs and lines - an image or pdf file would work best.
Avatar of Steve Sirica
Steve Sirica
Flag of United States of America image
Not for free is ain't.  I'm out!
ASKER CERTIFIED SOLUTION
Avatar of Sethi
Sethi
Flag of India image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of vinnyd79
vinnyd79
How about capturing the form,then saving as a picture:

http://support.microsoft.com/default.aspx?scid=kb;en-us;161299
Avatar of Marv-in
Marv-in

ASKER

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