how do i save a file based on the information in a specific cell to a specific file path-- Garry E
G Garry E Jul 3, 2006 #1 how do i save a file based on the information in a specific cell to a specific file path-- Garry E
D Dave Peterson Jul 3, 2006 #2 You could use a macro. Option Explicit sub SaveMe() Thisworkbook.saveas filename:="C:\yourpath\" _ & thisworkbook.worksheets("sheet9999").range("a1").value 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
You could use a macro. Option Explicit sub SaveMe() Thisworkbook.saveas filename:="C:\yourpath\" _ & thisworkbook.worksheets("sheet9999").range("a1").value 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
