+ Reply to Thread
Results 1 to 3 of 3

VBA select all items in active folder and print all items in folder

  1. #1
    Forum Contributor
    Join Date
    08-07-2014
    Location
    London
    MS-Off Ver
    10
    Posts
    148

    VBA select all items in active folder and print all items in folder

    Hi all

    I was wondering if someone could help. I need a VBA code that will allow me to select all items in the active folder and then print all the items, the following code allows me to open a folder... I want to add to this code if possible...

    Please Login or Register  to view this content.
    Any help would be appreciated.

    Thanks all

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,236

    Re: VBA select all items in active folder and print all items in folder

    https://www.mrexcel.com/forum/excel-...directory.html
    http://www.excelhowto.com/macros/pri...s-in-a-folder/
    https://www.exceltip.com/printing-in...oft-excel.html
    https://www.mrexcel.com/forum/excel-...es-folder.html
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  3. #3
    Forum Contributor
    Join Date
    08-07-2014
    Location
    London
    MS-Off Ver
    10
    Posts
    148

    Re: VBA select all items in active folder and print all items in folder

    Thanks, Sintek

    I have seen the majority of those. However, a lot of them refer to the printing of just workbooks, I need all items emails/word documents etc...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Telling excel NOT to load items that are in the XLstart folder
    By scottiex in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-02-2017, 05:12 PM
  2. Issue with folder selected items
    By shiva_raj in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-27-2017, 10:52 PM
  3. OUTLOOK 365 - Move items to folder
    By fabien1 in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 10-19-2016, 12:02 AM
  4. Moving Mail items from a sub folder to another sub folder
    By CR7 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-09-2015, 09:45 AM
  5. Folder.Items.Filter and Item.ExtendedProperty not Working
    By k64 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-22-2015, 12:30 PM
  6. Select Multiple Items in a List and then Print Those Items
    By dcdoc in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-26-2013, 01:16 PM
  7. Hyperlink from items recently put in a folder
    By Xx7 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-23-2011, 12:36 AM

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