Find and replace certain text...
-
- 4StarLounger
- Posts: 432
- Joined: 23 Mar 2017, 19:51
Find and replace certain text...
Hello Friends, Firstly I need from web hyperlink find some ID and replace with listed Id cods so that then i can with one click to open web in this destination. How can I do this? =404419214& from this replace to =200006322& and so on like in list....Thanks in advanced...
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 78235
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Find and replace certain text...
Enter the following formula in F2:
=HYPERLINK("https://reportal.ge/forms.aspx?payerCode="&A2&"&SystemID=1&show=1")
Fill down.
=HYPERLINK("https://reportal.ge/forms.aspx?payerCode="&A2&"&SystemID=1&show=1")
Fill down.
Best wishes,
Hans
Hans
-
- 4StarLounger
- Posts: 432
- Joined: 23 Mar 2017, 19:51
Re: Find and replace certain text...
Thanks, but then I need to download this report from this web. How can i execute this with vba or something else??
Please help this is very important for me....
Please help this is very important for me....
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 78235
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
- 4StarLounger
- Posts: 432
- Joined: 23 Mar 2017, 19:51
Re: Find and replace certain text...
Is there way to download this files with script in batch?
-
- Administrator
- Posts: 78235
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Find and replace certain text...
I'm sure there is, but I know very little about programmatically interacting with web pages.
Best wishes,
Hans
Hans
-
- 4StarLounger
- Posts: 432
- Joined: 23 Mar 2017, 19:51
Re: Find and replace certain text...
Thanks..