Hello. I sorry for my manners. Thanks for your reply.
I did change the file name, "(Filename:="C:\User\FullPath\WorkbookBname.xlsx")" to
(Filename:="C:\Users\Corey\Desktop\Anton Heatwave\PMI").
and I made and error to state where I want to paste the values.
from:
.Range("B" & Rw) = WbSource.Sheets(Country).Range("F2")
.Range("C" & Rw) = WbSource.Sheets(Country).Range("G2")
To:
.Range("C" & Rw) = WbSource.Sheets(Country).Range("F2")
.Range("D" & Rw) = WbSource.Sheets(Country).Range("G2")
But somehow, it don't seems to work.
How can I get around this?
Thanks in advance