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 |
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 |
ActiveWorkbook.SaveAs
On Jan 15, 8:08*pm, 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 ActiveWorkbook.SaveAs FileName:="C:\Documents and Settings\AnyPath\" & FiName & ".xls" |
All times are GMT +1. The time now is 09:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com