ActiveWorkbook.SaveAs
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
|