Find and replace certain text...

vaxo
4StarLounger
Posts: 432
Joined: 23 Mar 2017, 19:51

Find and replace certain text...

Post by vaxo »

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.

User avatar
HansV
Administrator
Posts: 78235
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Find and replace certain text...

Post by HansV »

Enter the following formula in F2:

=HYPERLINK("https://reportal.ge/forms.aspx?payerCode="&A2&"&SystemID=1&show=1")

Fill down.
Best wishes,
Hans

vaxo
4StarLounger
Posts: 432
Joined: 23 Mar 2017, 19:51

Re: Find and replace certain text...

Post by vaxo »

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....
You do not have the required permissions to view the files attached to this post.

User avatar
HansV
Administrator
Posts: 78235
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Find and replace certain text...

Post by HansV »

I cannot help you with that, sorry.
Best wishes,
Hans

vaxo
4StarLounger
Posts: 432
Joined: 23 Mar 2017, 19:51

Re: Find and replace certain text...

Post by vaxo »

Is there way to download this files with script in batch?

User avatar
HansV
Administrator
Posts: 78235
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Find and replace certain text...

Post by HansV »

I'm sure there is, but I know very little about programmatically interacting with web pages.
Best wishes,
Hans

vaxo
4StarLounger
Posts: 432
Joined: 23 Mar 2017, 19:51

Re: Find and replace certain text...

Post by vaxo »

Thanks..