I'm trying to modify an Excel 2003 macro that will open a workbook in a folder, print it, close that workbook, open another one and keep printing and closing workbooks in the folder until they're all printed. I know I can no longer use "Set fs = Application.FileSearch" in Excel 2010, but I don't know or understand the alternatives. The macro I used before the change to 2010 is listed below. I would appreciate it if someone could show me how to replace the "Set fs = Application.FileSearch" with the new and accepted alternative. Thanks in advance! JPDutch
Bookmarks