Forum

Hi Salim, Maybe rearranging your data so that it is in a format that will work with the functions in Excel is a better solution than requiring a co...

Hi Salim, Isn't this the same problem I answered here Regards Phil

Hi Audrian, Glad you got it sorted out. If there are 2 tables with the same id then the HTML is invalid/incorrectly written. An id should be uni...

Hi Salim, Please always start a new topic for each new question. You can use VLOOKUP to solve this - see attached. Regards Phil

Hi John, Please provide your workbook when asking a qs like this. I can't look at the code modules or the sheet contents to answer you properly. ...

You're welcome.

Hi Audrian, You need to let me now what line is generating that error. What line is highlighted in yellow in the debugger? I'd guess that the V...

No worries 🙂

You're welcome Salim.

Hi Audrian, Use F8 to step through the code. You can see exactly what is happening then, check your variables and objects etc. Please read those ...

Hi Audrian, No need to click on the Quote icon when replying, it just adds clutter to the thread and will be deleted 🙂 Please just click on the 'A...

Hi Audrian, That would indicate that something is wrong with HTMLTable.Rows.Length. Which could mean that there isn't a table stored in HTMLTable....

Hi Daniel, and when you step through the code, what value does fileLoc & fileStr have? Does fileLoc exist and is fileStr a valid filename? ...

No worries, you can always create a dummy file with just a few examples of the data. Thanks for letting us know you got it figured out. Regards ...