Open file and print sheets based on data in cell
Hi everyone. In column A I have the full path of a file. In columns B
through AZ I have sheet names within that file. How can I code excel to
open the file in A1, print the sheets in B1 through AZ1, then close the
file, then move to the next row and do the same until all rows containing
data in column A have been looped though? Thank you in advance.
PS - Some files may only have 2 sheets to be printed, so D1 through AZ1 may
be blank.
|