| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Print a File or Control
Excel 2003. FIRST, I want to just be able to print (to my default printer)
the contents of a text control on a user form. I was given the following code, but the printout is funky (margins are super narrow). Dim PrinterName As String, I As Integer I = InStr(Application.ActivePrinter, " on ") PrinterName = Mid(Application.ActivePrinter, 1, I - 1) Open PrinterName For Output As #1 Print #1, ProcessStatus.ProcStat.Text Close #1 IS THERE A BETTER WAY TO ACCOMPLISH THIS? SECOND, How does one print out an external file from Excel VBA code. Suppose for instance that I want to print out file "Test.txt." How would I program that? Thanks for the help and God bless. -- Dr. Doug Pruiett Good News Jail & Prison Ministry www.goodnewsjail.org |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ADDING A PRINT CONTROL BUTTON | Excel Worksheet Functions | |||
| Control item PRINT in menu FILE of Excel | Excel Discussion (Misc queries) | |||
| How do I print from a file created from sending a print to a file | Excel Discussion (Misc queries) | |||
| Disable printPreview's Print Control! is it possible???? | Excel Programming | |||
| Print Control in Word/Excel | Excel Programming | |||
Threaded Mode
