I need help with a button Ive been tinkering around with.

We use touch screens and I need to develop a button that when pressed saves-as an excel file. We are using 2007.

It needs to reference a cell for the save as. Example "H1" cell is a serial number to a quote for a client. So it would have to save as something like "1000 Clientsnamehere Dategoeshere.xls"

Is this do-able? Ive seen online some people can get it to work, but Ive never been able to.

Please help! :confused:

Figured it all out on my own :) Go me!