View Single Post
  #1   Report Post  
markx
 
Posts: n/a
Default workbook sheets into separate files

Hello guys,

Any idea how to write a simple and "elegant" macro that could "convert" all
the tabs from an open workbook into separate files (without destroying the
original file)?
- with the new files' names being the old tab names
- with a kind of "paste special/values" applied to every sheet (in order to
eliminate any particular issues that could arise from the (potentially)
existing links between the initial tabs).

Thanks a lot for any help on this!
Markx