how do i save a file based on the information in a specific cell to a
specific file path--
Garry E

You could use a macro.

Option Explicit
sub SaveMe()

Thisworkbook.saveas filename:="C:\yourpath\" _
& thisworkbook.worksheets("sheet9999").range("a1").v alue

end sub

But there's not validity checks in this at all.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Garry E wrote:

how do i save a file based on the information in a specific cell to a
specific file path--
Garry E

--

Dave Peterson