Saving by Cells

[JonesZoid]

Hi All,
If i had some cells containing information i wished to use for the Saved File Name - how would i go abut it.
E.g, A1 - Site, B1 - Name, C1 - Area, D1 - Eng.
How could i get it to save (By pressing a button(Already Made)) as E.g Site1_Name1_Area1_Eng2.xls

This would stop a lot of naming convention issues i have....

JonesZoid

[martindwilson]

try this code in a new module then assign button to it

Please Login or Register  to view this content.

[JonesZoid]

I changed the sheet and cell references - but everytime i run the code i get a debug error - which points at.

Please Login or Register  to view this content.

When i hover over the "a" - it appears empty although there is text in cell e3.

Any ideas..

[martindwilson]

works ok for me,see atached,
you need to save the sheet first time with the code in otherwise the variables wont populate.