Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Macro for saving file as cell ref
Hi
New to this site not sure if I am poisting in the correct area or not. I currently have a macro that prints off certain copies of my spreasheet when ran. I am now looking to add if possible that the file Autosaves when the macro is ran after all copies have finished printing. But I want it to save in a certain folder under the filename from a certian cell in my spreadsheet. Any ideas, your help will be gratly appreciated. Thanks Dave |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro for saving file as cell ref
Dave Turner wrote :
Hi New to this site not sure if I am poisting in the correct area or not. I currently have a macro that prints off certain copies of my spreasheet when ran. I am now looking to add if possible that the file Autosaves when the macro is ran after all copies have finished printing. But I want it to save in a certain folder under the filename from a certian cell in my spreadsheet. Any ideas, your help will be gratly appreciated. Thanks Dave Assuming the path/filename is stored in A1... Dim sFilename$ 'as string sFilename = Range("A1").Text ActiveWorkbook.SaveAs sFilename -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
File Saving macro ?!?! | Excel Programming | |||
Saving worksheet in new file with date AND cell value as file name | Excel Discussion (Misc queries) | |||
Saving a file in a macro | Excel Programming | |||
Saving a file(new) using the multiple cell contents as a file name | Excel Programming | |||
Saving a new file with a macro | Excel Programming |