vba foundfiles rename tab

  1. S

    VBA - Renaming and saving worksheets in closed workbooks

    Hey everyone. I have a problem that seems simple but I really can't find an answer: I'm trying to simplify my macro which opens all of the excel files in the directory and pulls data from a specific worksheet. The problem is that now there is two worksheets; Work(OPT#1) and Work(OPT #1) ---...

Some videos you may like

This Week's Hot Topics