workbook sheets into separate files

  • Thread starter Thread starter markx
  • Start date Start date
M

markx

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto saving sheets from a workbook as separate files. 1
How to separate Excel Workbooks into new files 0
Variable to rename a tab in a worksheet via VBA 5
Select sheet tabs in workbook & save to separate workbook files 2
Copying Worksheets From Different Workbooks using Marco 4
Append shortcut link to open a particular workbook TAB 1
forcing specific sheet opening upon launch of .xlsx file 4
How do I set up worksheet tabs to change based on a workbook cell 1

Back
Top