Saveas Macro with current date

How do I create a macro that will save a workbook to a specific location using a specific name along with the current date and be in a specific format (.xls)?

This is what I have so far:
Private Sub SaveFile_Click()
ActiveDocument.SaveAs Filename:="C:\Documents and Settings\All Users\Shared Documents\VendPerf " _
& Format(Date, "mm-dd-yy"), FileFormat:=56
End Sub

All it does though, is generate an error that says "Cannot run the macro "Vendor Performance.xls'!ThisWorkbook.SaveFile'. The macro may not be available in this workbook or all macros may be disabled."

I have verified that the macros for the workbook are running. Do I have this worded wrong or is it in the wrong place? Thanks!

I have tried it in "ThisWorkbook" and in "Sheet2". Sheet2 is where I have my instructions and another macro that calls up the userform. Is there another location that I should try?

Edit: oops, forgot to reply about how I'm calling it. I have a forms button on Sheet2.

I'm really new to this. I just started learning how to do programming last week. What is the difference between an ActiveX control and a forms control? How do I know which one I'm using? The button that I want to attach to the macro is on Sheet 2. Does that help?

I tried moving the code over to Module1. That didn't help. It still gives me the same error. Do I need to initialize that module? or do something else to it?

I just tried to re-attach the macro to my button to see if that would help and I noticed that it's not in the macro list. Could I have some syntax wrong?

Okay, that got me a bit further. Now I'm running into an error where Excel can't access this location: C:\Documents and Settings\All Users\Shared Documents\

I have to have each person save to a place on their own harddrive because we don't have a shared drive that everyone has access to. Each user has their own ID specific folder that My Documents resides in and I don't know how to create a path for that. Is there a way to save it to the desktop? Or create a folder on the desktop?

Nevermind...I can look up how to create a folder on the C: drive. I will do that. Thank you very much for your help!

I don't know where my other comment went...

Would it be easier to create a folder on the C:\ drive and save to there? One other thing to consider is that multiple files will be saved. I only want to create the new folder once. After the folder is created, I just want to save to that location. Is there a way to check to see if the folder exists and only create it if it doesn't?

Sorry, my PC is slow. I missed your comment. I believe that it would be better to put it on the C:\ drive so as to not clutter up the desktop. You've gone to a lot of trouble writing that code though and I hate to ask more of you.

You completely ROCK! That worked. Thank you so much! If I knew where you were, I'd buy you a cookie. As it is, can only offer my sincere thanks. Thanks!!!