G
Guest
I have the following function:
ActiveWorkbook.SaveAs Filename:=Range("filename").Value
Range("filename") contains:
=CONCATENATE(path,"\",Name2," ","2007",".","xls")
Problem:
I want to be able for the person to BROWSE and select the PATH to put into
the CELL = Range("path") so the person doesn't have to type it in.
thanks
Helmut
ActiveWorkbook.SaveAs Filename:=Range("filename").Value
Range("filename") contains:
=CONCATENATE(path,"\",Name2," ","2007",".","xls")
Problem:
I want to be able for the person to BROWSE and select the PATH to put into
the CELL = Range("path") so the person doesn't have to type it in.
thanks
Helmut