?
Solved

Print a Text File

Posted on 2000-02-23
4
Medium Priority
?
307 Views
Last Modified: 2010-05-02
Can I print a .txt file without opening it first? No formatting or page breaks are required. All I would need is for the program to print a predetermined file name and quit.
0
Comment
Question by:DonH040699
  • 2
4 Comments
 
LVL 7

Accepted Solution

by:
kamall earned 140 total points
ID: 2553161
Open "c:\myfile.txt" For Input As #1
Do while Not Eof(1)
   Line Input #1, x$
   Printer.Print x$
Loop
Close 1
Printer.EndDoc

0
 
LVL 5

Expert Comment

by:KDivad
ID: 2553284
Without opening it? Sure, if you don't mind "bouncing" it off command.com.

x = Shell("command /c copy " & MyFile & " lpt1")
0
 

Author Comment

by:DonH040699
ID: 2567112
Kamall,

I put your suggested code in a function and it worked great. VB showed me what else I could do with Print. and I wound up with a very useful untility. Thanks!
0
 
LVL 7

Expert Comment

by:kamall
ID: 2582143
You are welcome.
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Suggested Courses
Course of the Month8 days, 17 hours left to enroll

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question