Saving new file in working directory

[dl7631]

Hi!

I created a macro. At the end of this macro I want to save my active workbook as a new file. Here is what I wrote:

ActiveWorkbook.SaveAs Filename:= _
"TV&Radio_" & Sheets("Template").Range("B7") & ".xlsx", FileFormat:= _
xlOpenXMLWorkbook, CreateBackup:=False

Problem: It saves the file under "MyDocuments". However, I want it to be saved in the same directory that I am working in.

Advice?

Thanks a lot!

 

[dl7631]

Sorry, not sure where exactly I should put a \
Do you mind writing the whole line of the code with "\" included?

In other programs you can do it very easily and in a very straightforward way. For example, in R whenever you do NOT specify the directory it automatically saves things in your working folder.

Thanks!

 

[TiaXL]

ActiveWorkbook.SaveAs (sPath & "\TV&Radio_" & Sheets("Template").Range("B7") & ".xlsx")

 

[dl7631]

I tried:

ActiveWorkbook.SaveAs (sPath & "\TV&Radio_" & Sheets("Template").Range("B7") & ".xlsx")


It worked. Thanks a lot for your help!