Ok Here is an my objective:
I am devoloping a data base to link to a spread sheet that is changed daily. This excel file is posted on the common drive. I open the file and run a macro to clean it up and then another macro to save it under another file name. (I could probly do all this in one macro but i have not attempted yet) Any how What I want to do is Add a command button on to the switch board that will open the file and run the macros and close the file.

Can any one help?