View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Little Penny[_3_] Little Penny[_3_] is offline
external usenet poster
 
Posts: 48
Default ActiveWorkbook.SaveAs



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