+ Reply to Thread
Results 1 to 2 of 2

Printing Folder Contents

  1. #1
    Registered User
    Join Date
    10-31-2011
    Location
    Leicester
    MS-Off Ver
    Excel 2007
    Posts
    6

    Printing Folder Contents

    Hi,

    i have made a form that looks at a folder and displays the contents in a treeview. depending on which file is selected, i can open the file with a button. I am trying do 2 things-

    1. Print the selected file
    2. Print the complete file contents.

    The contents of the folders range from PDF, word, jpg

    i need to do this in VBA but seem to be struggling. Im an Access programmer and im a little rusty in excel nowadays fnarr

    any help greatly appreciated


    Cheers

    Nidge

  2. #2
    Valued Forum Contributor
    Join Date
    12-16-2004
    Location
    Canada, Quebec
    Posts
    363

    Re: Printing Folder Contents

    Not sure on how to print the content of textbox1.txt

    To print a UserForm you can use the code

    Me.PrintForm

    Placed under a CommandButton
    Denis

    Please always attach the sample workbook without sensitive information when asking for help

    To add a module
    Press Alt + F11 (this is the Visual Basic Environment)
    Insert Menu, select Module
    Past code there
    Close Visual Basic Environment (X)

+ 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