VBA to save file instead of .GetSaveAsFilename

[Freedox]

Heya,

Does anyone know how to change instead of prompting to save the file as to just save it without prompt to a location that is set in "ThisFile"?

Code I have now:

FileName = Application.GetSaveAsFilename(InitialFileName:=ThisFile, filefilter:="XML (*.xml),*.xml")

Code for ThisFile:

ThisFile = xmlPath & Worksheets("XML").Name & "_" & Format(Date1, "ddmmyyyy-hhmmss") & ".xml"

So in other words in needs to just save file to xmlPath instead of promtimg eith .GetSaveAsFilename

Chers!

 

[Fluff]

How about

ThisWorkbook.SaveAs thisfile

 

[Freedox]

How about

ThisWorkbook.SaveAs thisfile

It saves the actual workbook instead of small snipped that is saved when prompted by .GetSaveAsFilename ... so this is not the right solution... :/

 

[Fluff]

In that case, could you please show us your entire code?
It's very difficult to help without all the info