+ Reply to Thread
Results 1 to 2 of 2

Printing a .txt file with VBA code?

  1. #1
    Forum Contributor PingPing's Avatar
    Join Date
    02-19-2010
    Location
    London, England
    MS-Off Ver
    2007
    Posts
    158

    Printing a .txt file with VBA code?

    I am working on building my own set of VBE tools which currently include exporting a VBA procedure as a text file.

    I would now like to be able to print that text file from within the VBIDE.

    Can anyone point me in the right direction on this one, please?

  2. #2
    Forum Expert
    Join Date
    03-31-2009
    Location
    Barstow, Ca
    MS-Off Ver
    Excel 2002 & 2007
    Posts
    2,164

    Re: Printing a .txt file with VBA code?

    You can look at PrintOut method. By using OpenTextFile method to read the file and put the file onto a temporary worksheet, then using PrintOut to send the worksheet to the printer.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1