| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
howto: saveas with file name from a cell in the current worksheet
see subject
|
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
howto: saveas with file name from a cell in the current worksheet
bob,
You can do it with vba. Here's a small snippet that you can assign to a command button. Where "A1" is the cell that you are using to name the file. This will save in the last folder you saved to. ActiveWorkbook.SaveAs Filename:=Range("A1").Value HTH Bigpig "bob" wrote: see subject |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
howto: saveas with file name from a cell in the current worksh
BigPig,
Thank you. I have that part, but what if I wanted to add in a specific folder to save it to? Where would I add the folder string? That's where my real issue is. Thank you again. ActiveWorkbook.SaveAs Filename:=???????Range("A1").Value Darren "BigPig" wrote: bob, You can do it with vba. Here's a small snippet that you can assign to a command button. Where "A1" is the cell that you are using to name the file. This will save in the last folder you saved to. ActiveWorkbook.SaveAs Filename:=Range("A1").Value HTH Bigpig "bob" wrote: see subject |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| howto: saveas with file name from a cell in the current worksheet | New Users to Excel | |||
| SAveAs worksheet | Excel Worksheet Functions | |||
| saveas CSV file | Excel Discussion (Misc queries) | |||
| I need current value of one worksheet into another cell? | Excel Worksheet Functions | |||
| File saves ok, SaveAs VERY slow | Excel Discussion (Misc queries) | |||
Linear Mode
