1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Excel Problem

Discussion in 'Windows & Other Software' started by fluiduk, 26 May 2006.

  1. fluiduk

    Wise Guy

    Joined: 13 Nov 2003

    Posts: 1,567

    Location: Manchester

    Hi All

    We use excel for our rotas at work which is fine. However, we have our rotas on our staff extranet. Is there anyway that I can set excel to upload a file on save?

    Or have some kind of script that can be run to upload the rota, and preferably change the file name to currentrota.xls?

    All ideas welcome

    Ta
    Aaron
     
  2. Mel_P

    Wise Guy

    Joined: 27 Feb 2004

    Posts: 2,143

    Location: Kent

    I would think that it could be done using VBA ?
     
  3. fluiduk

    Wise Guy

    Joined: 13 Nov 2003

    Posts: 1,567

    Location: Manchester

    Pardon my ignorance lol

    But what is that, and any ideas how I could do it.

    Thanks
    Aaron
     
  4. Mel_P

    Wise Guy

    Joined: 27 Feb 2004

    Posts: 2,143

    Location: Kent

    If you go to "tools" / "macro" in Excel you will see "visual basic editor" - it's a way of automating Excel to make it do things that you want.

    VBA = Visual Basic for Applications.

    Tricky stuff!