Multiple sheets in single workbook into new files only using cell format/values

[MacApple]

In a 20 tab workbook that I have I would like help in authoring a macro that will:
- Save each tab/sheet within the workbook as a new file (and subsequently save the sheets to the same file each time I run the macro). The name of the new file can be found in one of two places: the name of the tab and/or cell B4.
- When creating / overwriting the new spreadsheet, I would like the cell values and formats to be transferred to the new file, but not the formulas. The individual spreadsheets created from the "master" workbook will be sent out to various parties and as such, I simply want the values and formats transferred.

I am new to Visual Basic and as such, I do not have a great understanding of how to write something that will complete this task... I hope that someone can aid me in this project...

Thanks.

[StephenR]

The name of the new file can be found in one of two places: the name of the tab and/or cell B4.

How does one determine which? Give this a whirl, it uses the sheet name:

Please Login or Register  to view this content.

[MacApple]

I tried to run the macro, but it came back with the following error:

referencing the line: Dim ws As Worksheet
"BASIC syntax error
Unknown data type Worksheet"

What did I do wrong?

**I should note that I tried this on Open Office... I'll try it on MS Excel before stating that it was unsuccessful...