VB Script save a file in a specifed location as xml

Hi

I have a script that saves a file as XML but having a problem saving it to my specified location.

Sample code:
' My specified save location
strSavePath = "C:\Test\CWTest"

' File save to location
'------------------------------------------------------------------------  
   strFileName =  strSavePath & Left(oFile.Name,Len(oFile.Name)-3) & "xml"  
   Set File = FSO.createTextFile(strFileName, True)
   File.Write strXML
   File.Close

The file does save fine as an xml file but it keeps dumping into the test folder (next folder up) when i want to dump it into the CWTest folder

How can i amend it to save to 'CWTest' folder rather than the 'Test' folder
wilko1000Asked:
Who is Participating?
 
Saurabh Singh TeotiaCommented:
Change this line...

strSavePath = "C:\Test\CWTest"

Open in new window


To this..

strSavePath = "C:\Test\CWTest\"

Open in new window


Saurabh...
0
 
Bill PrewCommented:
You are missing the backslash between your last folder name, and the name of the file itself.  I typically do this like this:

' My specified save location
strSavePath = "C:\Test\CWTest"

' File save to location
'------------------------------------------------------------------------  
   strFileName =  strSavePath & "\" & Left(oFile.Name,Len(oFile.Name)-3) & "xml"  
   Set File = FSO.createTextFile(strFileName, True)
   File.Write strXML
   File.Close

Open in new window

~bp
0
 
wilko1000Author Commented:
Ah the backslash was missing, both solutions worked. (Saurabh) was the simplest but in fairness both soultions worked

Thanks you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.