Excel Problem

Associate
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
 
Soldato
Joined
27 Feb 2004
Posts
2,535
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!
 
Back
Top Bottom