run time error 1004

[ruxumuxu]

Hi everyone, I am a newbie in Excel Vba and I would appreciate your help!

I saw a couple days ago this link:

http://www.familycomputerclub.com/sc...nto-excel.html

Let’s say I want to scrape all ids from this, for example, "URL;http://quickfacts.census.gov/qfd/states/01000.html" ... *.01001 *.01002....x, x+1 and some ids are missing.

When this Excel VBA code running and cannot find an id then it stops the procedure.

I would like, if it possible, to change thw Excel VBA code to make a loop: If it finds an id then scrap it…if not continue…

Could you please help me!!!

Thanks a lot.

Mike

[protonLeah]

Please post your code and a sample of your workbook directly to this forum. We don't want to click on links to research your problem.

To attach a Workbook
(please do not post pictures or links to worksheets)

• Click Advanced (next to quick post),
• Scroll down until you see "Manage Attachments",
• Click that then select "add files" (top right corner).
• Click "Select Files" find your file, click "open" click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Click "Done" at bottom right to close the Attachment Manager.
• Click "Submit Reply"

[ruxumuxu]

The problem is solved. Thank you!