I'm using the bit of code to save my workbook base on the value in a
cell.

ActiveWorkbook.SaveAs FileName:=FiName

But it always savse in the my doc folder. Can I force it to save in
the folder of my choice.


Thanks

Make sure you include the path somewhere--in the code or in the cell:

ActiveWorkbook.SaveAs FileName:="C:\yourfolderhere\" & FiName



Little Penny wrote:
>
> I'm using the bit of code to save my workbook base on the value in a
> cell.
>
> ActiveWorkbook.SaveAs FileName:=FiName
>
> But it always savse in the my doc folder. Can I force it to save in
> the folder of my choice.
>
> Thanks

--

Dave Peterson

On Jan 15, 8:08*pm, Little Penny <LittlePenn...@gmail.com> wrote:
> I'm using the bit of code to save my workbook base on the value in a
> cell.
>
> ActiveWorkbook.SaveAs FileName:=FiName
>
> But it always savse in the my doc folder. Can I force it to save in
> the folder of my choice.
>
> Thanks

ActiveWorkbook.SaveAs FileName:="C:\Documents and Settings\AnyPath\" &
FiName & ".xls"