help needed in VB

**jp_1726qc** · 12-08-2009, 08:32 PM

Hi,

I'd like to extract multiple page from a web site. I'd like to use a for loop but I'm not sure about how doing it. The problem is that the variable to increment is in the url. I want to generate a for loop able to change the last caracter (pg=2). I tried to simply replace the number by the variable but this generate error in the code.

Here is the code generated by excel.

Please Login or Register  to view this content.

Can someone help me with that?

Thank you

**shg** · 12-08-2009, 08:34 PM

Welcome to the forum. jp.

Please take a few minutes to read the forum rules, amend your thread title accordingly, and add code tags.

Thanks.

**chrns12** · 12-08-2009, 09:02 PM

It's going to be something like this:

Please Login or Register  to view this content.

**jp_1726qc** · 12-08-2009, 10:51 PM

It worked perfectly.

Thank you.

Sorry, I will read the forum rules

**royUK** · 12-09-2009, 03:40 AM

Originally Posted by jp_1726qc

It worked perfectly.

Thank you.

Sorry, I will read the forum rules

Read the forum Rules & use the correct thread Title formats. Future posts will be closed.

jp_1726qc, please do not answer questions when a senior member has pointed out a Rule infringement