VB Code to save the file with name in certain cell

**rizmomin** · 10-04-2015, 10:48 AM

Hello:

Please refer to attached file.

I need VB Code to perform following.

I need to copy DEST.xlsm from location in Cell D21 to the same directory with the file name
in cell D24.

Let me know if you have any questions.
Thanks.

RM

**LeoTaxi** · 10-04-2015, 12:11 PM

Cell D1 is empty

**rizmomin** · 10-04-2015, 12:34 PM

Hello:

I am sorry, it is suppose to be D21.
Please help.
Thanks
RM

**rizmomin** · 10-06-2015, 11:10 PM

Hello:

Can someone help with this.
Thanks a lot
Riz

**Saranya Arikrishnan** · 10-07-2015, 03:29 AM

Hi,

Please try using the below code,

Sub Macro1()

Workbooks.Open Filename:="D:\DEST.xlsm"

Windows("DEST.xlsm").Activate
ActiveWorkbook.SaveAs Filename:="D:\Store1_Weekly_TimeData_09212015.xlsm", _
FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False
ActiveWindow.Close

End Sub

Regards

,
Saranya

VB Code to save the file with name in certain cell

LinkBack

Thread Tools

Rate This Thread

Display

VB Code to save the file with name in certain cell

Re: VB Code to save the file with name in certain cell

Re: VB Code to save the file with name in certain cell

Re: VB Code to save the file with name in certain cell

Re: VB Code to save the file with name in certain cell

Thread Information

Users Browsing this Thread

Similar Threads

Excel vba code to save each page as a pdf file with filename from cell reference

Need help with code to save file in a folder location based on a cell value

[SOLVED] VBA code to save current worksheet as temporary PDF file and then add to my existing code

Excel 2010 file with VBA save and send code works-but file can't be found.

[SOLVED] Code to save as PDF and name file as Cell Text

VBA Code to share file and save file

Amend Code - Save file with cell as name from different sheet.

Bookmarks

Bookmarks

Posting Permissions