Auto file naming
 

Hi There

Is it possible to automatically name a file based on two cell entries when
saving.

E.G

A1 B1
20090623 ZVN462A

I need the filename to be 20090623 - ZVN462A and this must be automatically
done.

Thanx in advance

Auto file naming
 

An easy way to learn is to record a macro while doing the save. Then clean
up and modify to change the name to your string

mystring=range("a1") & " - " & range("b1")

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jacquesvv" wrote in message
...
Hi There

Is it possible to automatically name a file based on two cell entries when
saving.

E.G

A1 B1
20090623 ZVN462A

I need the filename to be 20090623 - ZVN462A and this must be
automatically
done.

Thanx in advance