+ Reply to Thread
Results 1 to 5 of 5

VBA to batch print .doc files form variable path

  1. #1
    Forum Contributor
    Join Date
    01-18-2013
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    641

    VBA to batch print .doc files form variable path

    I'm trying to use VBA to print multiple Word files one after another in a batch.

    I'd like to run the macro from within Word , and have a dialog box ask for the path for the folder where the .doc files to be printed are.

    Having entered the path it would then print them one after the other , perhaps having the print dialog show for the first of the batch.

    Can someone help with some code to achieve this?

    Grateful for any help.

    Using Excel , Word and Access 2003 - For the whole of 2024

  2. #2
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: VBA to batch print .doc files form variable path

    For example:
    Please Login or Register  to view this content.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  3. #3
    Forum Contributor
    Join Date
    01-18-2013
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    641

    Re: VBA to batch print .doc files form variable path

    Many thanks for this. It works really well. The print dialog only asks for the user to say what the default printer is , rather than offering a way of changing the print properties. I got around this by setting them manually in advance , although this does make the dialog in the macro redundant of course.


  4. #4
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: VBA to batch print .doc files form variable path

    You didn't say which print dialog you wanted. Try deleting 'Setup'.

  5. #5
    Forum Contributor
    Join Date
    01-18-2013
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    641

    Re: VBA to batch print .doc files form variable path

    Ok - that's perfect. Many thanks.


+ 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. Open files choosing path in combobox and files in checkbox (user form)
    By Nastya621 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-10-2020, 11:32 AM
  2. Batch Print cheque from form template
    By seolann in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 07-24-2019, 04:47 AM
  3. [SOLVED] Merge different Excel/CSV files into one with variable in path name
    By nikats in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-22-2013, 05:45 AM
  4. [SOLVED] macro to batch print files listed in a spreadsheet
    By elgato74 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-07-2012, 05:46 PM
  5. Print batch of files via hyperlinks
    By excelbry in forum Excel General
    Replies: 0
    Last Post: 03-31-2011, 05:40 AM
  6. [SOLVED] Can I batch print several files at once with Excel?
    By blueberry in forum Excel General
    Replies: 0
    Last Post: 07-19-2006, 04:45 PM
  7. Replies: 1
    Last Post: 01-10-2005, 03:13 PM

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