Hi members .
can an excel macro automaticcalyi save sheets individually from a workbook that may contain 100,s of separate sheets.
each sheet would need to be saved in a text format and named the same as the A2 cell in each sheet.
saved in the same folder, e.g. C:sheets
thanks.
mike.
can an excel macro automaticcalyi save sheets individually from a workbook that may contain 100,s of separate sheets.
each sheet would need to be saved in a text format and named the same as the A2 cell in each sheet.
saved in the same folder, e.g. C:sheets
thanks.
mike.