Home » Forums » Open Source Learning Center » Question and Answer

Save As function

Submitted by gramercynewyork on 30 July, 2013 - 19:29

Hello,

I want to save a file with path and file name contained in cell C2, and current date saved in C1.

For example, I have in cell C2 ="C:\RL\RL REVAMPED 2012-1 TB as of "&TEXT(C1,"YYYYMMDD")&".xlsm" and in cell C1 I have today's date.

I tried typing the following code below but I get an error message that there is a break in code.

ThisWorkbook.SaveAs Filename:=range("C2")

Thanks in advance for your help,

GNY

‹ Solution How to tranpose 2 column excel spreadsheet by column A group copy as picture gives me always a yellow background ›
»
Vikas Verma's picture

Try this

Submitted by Vikas Verma on 21 March, 2014 - 08:56.

ThisWorkbook.SaveAs Filename:=range("C2")& "\" & Format(C1,"YYYYMMDD")&".xlsm"

Hope it will help you

»