PDA

View Full Version : VBA Application to print multiple, user selected files



robwood83
08-03-2010, 08:16 AM
Hello all, I have had a problem that has been giving me fits for a while. I need a VBA macro that will allow the user to select multiple folders and then print all excel documents in that folder. To make it even more difficult, I only want to print the sheet named "Turn-In". Any help would be really appreciated, this has caused me nothing but grief. I received one example in VBS that seemed to work, but when I tested it I was getting an ActiveX error in anything newer than Windows XP. This would be run on Windows Server 2003 if that makes a difference.