Results 1 to 2 of 2
  1. #1
    MatthewGrace is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jan 2013
    Posts
    159

    Print All Excel Files In A Specific Folder

    Thank you all for considering my post.

    My goal is simple: Print every .XLS file in a folder C:\ThisFolder. The XLS's will always have different names every day, so the goal is to enumerate each xls file in that folder irrespective of its name and print.

    As for which Worksheets to print, I have already done a SetPrintArea within Excel for each of the files in questino. Today, I can open any of these Excel files manually in Windows Explorer and press Ctrl+P>>Print and everything happens perfectly. My goal therefore is to have Access load up every Excel file and press Ctrl+P and send to the default Printer then close the file, then repeat for every XLS in the Folder.



    Thank you much for any insight,
    Matt

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,861

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 11
    Last Post: 02-14-2019, 10:27 AM
  2. Replies: 5
    Last Post: 03-21-2018, 06:53 PM
  3. Import 4 Different Excel Files from One Folder
    By Chaser in forum Import/Export Data
    Replies: 2
    Last Post: 10-20-2017, 10:17 AM
  4. Replies: 10
    Last Post: 09-09-2015, 03:25 AM
  5. Copy files into specific folder
    By Jan22 in forum Access
    Replies: 12
    Last Post: 04-17-2012, 08:27 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums