Hello everyone,
I'm trying to create a button where the macro saves the workbook in three different folders and names the workbook using cell AD. Cell AD has the formula =TEXT(NOW(),"MM.DD.YY H.MM AM/PM"). I know how to save sheets in multiple folders but have never done this with an entire workbook. Any help is appreciated.
I'm trying to create a button where the macro saves the workbook in three different folders and names the workbook using cell AD. Cell AD has the formula =TEXT(NOW(),"MM.DD.YY H.MM AM/PM"). I know how to save sheets in multiple folders but have never done this with an entire workbook. Any help is appreciated.