Need a macro to save an active file in another folder as a name that is located in a cell

**birdgirl** · 09-22-2015, 02:08 PM

Please I need a macro to save an open/active file (whole file) in a new location - "L:\Customization\QUALITY\CN's & CAR's\CN & CAR Reports 2015" - also the specific file name I want to use for the new file is the result of a formula that is located in cell "W1" on the active sheet.

Also if it's not too complicated - once the file has been saved and renamed can the macro copy cells I2:N2 on the active sheet and paste special value on top of these cells - I want to remove the formulas and relpace with the values in these cells.

**JBeaucaire** · 09-22-2015, 02:22 PM

The SaveCopyAs method should work:

ActiveWorkbook.SaveCopyAs "L:\Customization\QUALITY\CN's & CAR's\CN & CAR Reports 2015" & ActiveSheet.Range("W1").Value

Play around with that.

Then:

With ActiveSheet.Range("I2:N2")
    .Value = .Value
End With

Need a macro to save an active file in another folder as a name that is located in a cell

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Need a macro to save an active file in another folder as a name that is located in a cell

Re: Need a macro to save an active file in another folder as a name that is located in a c

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Lookup folder from cell text, then save excel file in this folder

[SOLVED] Save File to folder Where folder is referenced in cell

[SOLVED] Macro to Save File to Location Folder Based on Date in Cell

[SOLVED] macro to save file to specific folder with file name from cell reference

Macro to save duplicate file and create folder name based on cell value

Get 3 cell values from all the excel files located in folder & make table in master file

Macro - Open up file based on search filter located in folder with various subfolders

Bookmarks

Bookmarks

Posting Permissions