Automatically extract website data to a spreadsheet

[KS-10]

Hello everyone.

Someone has help me create a stock report sheet which can automatically scrap data of 100 companies into excel.

Here is the reference link: https://www.mrexcel.com/board/threads/automatically-extract-website-data-to-a-spreadsheet.1196610/page-3#posts

The problem here is this.
The workbook does not work on my side only on the developer side.

We have tried multiple ways but nothing worked on my side.
Please view ling of my error: https://drive.google.com/file/d/1BugIqxWpc66bnsXtuKTNakjy8JZ0tU8c/view?usp=sharing


I am requesting if anyone can download and test to see if you has the same problem as I do and what steps I can make to fix the problem?

Thanks in advance

Please view files below...

Cheers

[boa]

Здравствуйте,
попробуйте заменить .Text на .Value, может помочь...
иначе, надо просто вникать и заниматься тестированием (((