title: Save CSV file to another location without opening the new file
body: <p>I dont have much VB experience, but i tries to do a simple thing.</p>
  
  <p>I need a open excel worksheet to copy itself to another location. Then It should just continue with the existing worksheet and not open the copy that it has made.</p>
  
  <p>I have used this code for now:</p>
  
  <pre><code>Sub savecsv ()
  ActiveWorkbook.SaveAs "C:\test\testing.csv", FileFormat:=6
  End Sub
  </code></pre>
  
  <p>This code saves the worksheet to a new location, but it also opens the new one.
  I have googled a bit and found out that i can use SaveCopyAs to obtain my goal, so i have tried to edit the above code to that, but then i get the error: "Compile Error: Wrong number of arguments or invalid property assignment"</p>
  
  <p>Can someone help me with a code that works? And also a way to owerwrite the file it creates automaticly and not ask if i want to owerwrite the existing file.</p>