Hi
I would like to create a simple excel macro which modifies text in an existing file, using values located in an excel sheet.
I want the macro to open the text file (which is located in a specific folder), to find the text located in excel's cell A1 and find standard keyword, and to replace it by excel's cell B1. Then, it should find the text located in excel's cell A2, and to replace it by excel's cell B2, and so on.
Example:
In my worksheet I have two columns “REFNAME (in column A1)” and “Designnote (in column B1)” with values . My requirement is, first finds the REFNAME and again finds next keyword and then replaced with B1 values.
<description><questionref id="c08c9e11-b53d-4203-b82c-66776a50aed3">
Text File Example
RefName="CMSTDTCIT" xmlns="http://phaseforward.com/CSML/2009-06-11"><Description /><CustomProperty><Name>Item Required</Name><Value>true</Value></CustomProperty><CustomProperty><Name>SDV Required</Name><Value>true</Value></CustomProperty><Title>CMSTDTCIT</Title><QuestionRef Id="c08c9e11-b53d-4203-b82c-66776a50aed3" />
in above lines "CMSTDTCIT" will be available in A1 cells and again system should fine the next standared keyword (keyword is =<Description />)
<description>
so i want to replace the text <Description /><description> with B1 cell value.
Can anyone please help me with this issue, I've been trying it out myself but cannot find a solution.</description></description></questionref></description>
I would like to create a simple excel macro which modifies text in an existing file, using values located in an excel sheet.
I want the macro to open the text file (which is located in a specific folder), to find the text located in excel's cell A1 and find standard keyword, and to replace it by excel's cell B1. Then, it should find the text located in excel's cell A2, and to replace it by excel's cell B2, and so on.
Example:
In my worksheet I have two columns “REFNAME (in column A1)” and “Designnote (in column B1)” with values . My requirement is, first finds the REFNAME and again finds next keyword and then replaced with B1 values.
<description><questionref id="c08c9e11-b53d-4203-b82c-66776a50aed3">
Text File Example
RefName="CMSTDTCIT" xmlns="http://phaseforward.com/CSML/2009-06-11"><Description /><CustomProperty><Name>Item Required</Name><Value>true</Value></CustomProperty><CustomProperty><Name>SDV Required</Name><Value>true</Value></CustomProperty><Title>CMSTDTCIT</Title><QuestionRef Id="c08c9e11-b53d-4203-b82c-66776a50aed3" />
in above lines "CMSTDTCIT" will be available in A1 cells and again system should fine the next standared keyword (keyword is =<Description />)
<description>
so i want to replace the text <Description /><description> with B1 cell value.
Can anyone please help me with this issue, I've been trying it out myself but cannot find a solution.</description></description></questionref></description>
Last edited:
