Automator & excel

Discussion in 'Mac Apps and Mac App Store' started by verfre, Mar 25, 2009.

  1. verfre macrumors newbie

    Joined:
    Mar 25, 2009
    #1
    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!!
     
  2. LtRammstein macrumors 6502a

    LtRammstein

    Joined:
    Jun 20, 2006
    Location:
    Denver, CO
    #2
    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 -.
     
  3. verfre thread starter macrumors newbie

    Joined:
    Mar 25, 2009
    #3
    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..
     

Share This Page