New Workbook Name from Multiple Cells

[degmania]

To anyone with a spare moment;

I currently have some code that creates a new workbook from the active sheet and names it from a particular cell. I would like to change it so that it draws from two different cells and adds unchanging text to the file name.

The current code is;

Please Login or Register  to view this content.

How would I change this so that it creates a filename with cell I8, adds a space, adds contents of another cell, adds another space, and finishes with something like 'COMPANYA'.

Any help would be greatly appreciated!

[shg]

One way:

Please Login or Register  to view this content.

[degmania]

This is working perfectly. Thanks shg!