Hi,
This is very important for me.Request you to go through the query.
On my desktop i will have 10 flat files saved. With file Names Notepad1,Notepad2..Notepad10
Content of the flat file is :
Notepad1:
<!DOCTYPE html>
<html>
<body>
<a href="xyz.com Registry solutions for .xyz .college and .now gTLD's">
This is a link</a>
</body>
</html>
Notepad2:
<!DOCTYPE html>
<html>
<body>
<a href="http://www.xsz.com">
This is a link</a>
</body>
</html>
.
.
.
Notepad10:
<!DOCTYPE html>
<html>
<body>
<a href="http://www.xqz.com">
This is a link</a>
</body>
</html>
I shall have an excel file with various links in A(A1:A10) column.
http://www.xyz.com
Welcome
???????,??????????????
http://www.xyt.com
.
.
.
.
.
http://www.xqz.com
Now do i have any possibility to create a macro which opens the Notepad1 and paste the excel file A1 content in the required location in Notepad save and close it.
Excel file A1 content in Notepad1 link location
Excel file A2 content in Notepad2 link location
Excel file A3 content in Notepad3 link location
.
.
.
.
.
Excel file A10 content in Notepad10 link location
This is very important for me.Request you to go through the query.
On my desktop i will have 10 flat files saved. With file Names Notepad1,Notepad2..Notepad10
Content of the flat file is :
Notepad1:
<!DOCTYPE html>
<html>
<body>
<a href="xyz.com Registry solutions for .xyz .college and .now gTLD's">
This is a link</a>
</body>
</html>
Notepad2:
<!DOCTYPE html>
<html>
<body>
<a href="http://www.xsz.com">
This is a link</a>
</body>
</html>
.
.
.
Notepad10:
<!DOCTYPE html>
<html>
<body>
<a href="http://www.xqz.com">
This is a link</a>
</body>
</html>
I shall have an excel file with various links in A(A1:A10) column.
http://www.xyz.com
Welcome
???????,??????????????
http://www.xyt.com
.
.
.
.
.
http://www.xqz.com
Now do i have any possibility to create a macro which opens the Notepad1 and paste the excel file A1 content in the required location in Notepad save and close it.
Excel file A1 content in Notepad1 link location
Excel file A2 content in Notepad2 link location
Excel file A3 content in Notepad3 link location
.
.
.
.
.
Excel file A10 content in Notepad10 link location