Thank you paul sir,
You are great. Because of quick response and help my weekend is saved.
I could find a short term solution for my problem, but still I need to find
a permanent fix.
Thanks for all your help.
On Fri, Apr 1, 2016 at 9:53 PM, Paul Schreiner
wrote:
> Oops.
> Just realized that
Oops.Just realized that you need to specify the path for the output file!You
could specify the folder in some way, or take the path from the input file.to
do that, try this:
Option Explicit
Public Const ForReading = 1, ForWriting = 2, ForAppending = 8
Sub Replace_in_XML()
Dim fIN, fOut, fso,
There is a function called FORMAT()It takes and "expression" and outputs it in
a specified format.In your case, you'd like to take today's date and time and
show it as "MMDDYY-HH:MM AM/PM"This, you want to precede with
"HGSJAM-Encompass_" and follow with "_1.xml"
the result?
NewXML = "HGSJAM-Enc
Dear Paul,
thanks Sir, You made my day. . you are really a true and always help in
this group.
I just want one more thing, which will greatfully.
after making changes can the new file be saved in this name formate
"HGSJAM-Encompass_MMDDYY-HH:MM AM/PM_1.xml"
Please if I can get this help it wou
Try a macro like this:
Option Explicit
Public Const ForReading = 1, ForWriting = 2, ForAppending = 8
Sub Replace_in_XML()
Dim fIN, fOut, fso, I, XMLName, NewXML
Dim RowNum, NumRows, Str
Dim StrFrom, StrTo XMLName = ThisWorkbook.Sheets(1).Range("F7").Value
NewXML = Replace(XMLName
Dear Experts,
Greeting of the day,
I am new to XML coding, and got stuck somewhere.
Olease help me, I have one XML file with me, in which I want to change some
text using excel macro.
also the Replace what and Replace with text need to be taken from worksheet
cells.
I am attaching XML file as
