| || |
Problem in XML file writing
i have query to copy the file in xml but it is stop doing the process if it has special character e.g ? in the file
could anyone help me for this?
Set f = fso.OpenTextFile(fldr&"\"&"BatchFile"& i&".xml", ForWriting, True)
Re: Problem in XML file writing
Looking at your code you are opening a sequence of files with an .xml file extension in ascii format and then writing the contents of a database field to the file.
It won't fix your problem but I notice that you don't close any of the files - this will be ok most of the time but I gues you could eventually run out of file handles.
Your problem MIGHT be non-ascii characters in the database?