save to folder based on cell value

[Steve]

I have a contract that has a macro that will save to a particular location.
Is it possible to make the save location dependant on the first letter of
the save name.
Example: Save name "Smith, John" Since the first letter is S, I would like
it to save to a folder named "Q-S".
Thanks

[kassie]

Add a case statement to your macro, with an argument that checks the first
letter of the save name variable, and then sets your folder variable to the
appropriate folder

"Steve" wrote:

> I have a contract that has a macro that will save to a particular location.
> Is it possible to make the save location dependant on the first letter of
> the save name.
> Example: Save name "Smith, John" Since the first letter is S, I would like
> it to save to a folder named "Q-S".
> Thanks