My company has computer-generated reports that come out as Excel spreadsheets which are emailed to the Billing Department. They would like these reports to be automatically printed as they are received.
I already found a program that will automatically download email attachments, called Mail Attachment Downloader.
Now ideally, I would want a program which will:
- Scan a chosen folder for new XLS spreadsheets that are downloaded.
- Print them out.
- Get rid of them (preferably by moving them to a different folder).
I know I can just write a batch file to take care of #3; and #1 isn't really necessary. I could just have a program run at a certain time to automatically print out any files it sees, then follow it with a batch file to move the files somewhere else. But finding a program that will automatically print Excel spreadsheets has proven to be difficult.
I have seen some Excel macros that automatically print a spreadsheet, but I want it to automatically open them and print them all by itself.
One of the challenges I'm up against is the Billing Department doesn't have Microsoft Excel yet. In the very near future, they will have a computer with Excel 2010, but for now it just has LibreOffice.