Hi Guys,

I have a code which extracts data from the closed workbook, but recently i have noticed that from some workbook it retrieves data as a text i have highlighted in red which is as text, but rest of the files work fine and recognised as a values.

Hopefully somebody would be so kind and help me to adjust the code to retrieve data as values.

Thanks in advance.

Functions module code
Please Login or Register  to view this content.
Code in module
Please Login or Register  to view this content.