Automator & excel

[verfre]

Hello there,
I'm not so good at automator and I need some help.
I have a lot of excelsheet to make. Each sheet is about a customer ans should go to a specific folder.
As i am naming the folders by date followed by the name of the customer, it would be easy to fill the name in a cell. Can I expect automator to take the content of that cell and uwe it as a ame to save in a folder I should place in another cell.

P. ex.
cell A1 content 20090325/verfre/proposition
cell A2 content 2009/03/25verfre

Automator should name the file as 20090325/verfre/proposition.xlsx
and save it in the folder named 2009/03/25verfre.

Is that possible?

Thanks for helping me!!

 

[LtRammstein]

It would be possible, but you might need to do some Applescripting. The one thing I'd say is that don't put "/" in the names of your folders/files. It can get confusing, and sometimes it can cause Unix to not allow. Look into using _ or -.

 

[verfre]

OK, no problem.
I can change

cell A1 content 20090325/verfre/proposition
cell A2 content 2009/03/25verfre

Automator should name the file as 20090325/verfre/proposition.xlsx
and save it in the folder named 2009/03/25verfre.

to

cell A1 content 20090325_verfre_proposition
cell A2 content 20090325_verfre

Automator should name the file as 20090325_verfre_proposition.xlsx
and save it in the folder named 20090325_verfre.

...and I should do some applescripting. ( I know that..:-( )
And that's my problem. I am looking over all the net to learn how to do it, but it seems I do not succeed in it. Can you give me a little hand? Please..