Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with ActiveWorkbook.SaveAs | Excel Programming | |||
ActiveWorkbook.SaveAs | Excel Programming | |||
ActiveWorkbook.SaveAs Returns | Excel Programming | |||
ActiveWorkbook.SaveAs problem | Excel Programming | |||
activeworkbook.saveas | Excel Programming |