Vlookup from other file

[VBA Newbie1]

Hello all,

I am currently trying to write a VBA-Code, which should use a Vlookup to get specific data from another workbook. (The column from which it should take the data should be flexible based on the month, which is why I implemented "ZielSpalte")
By now, I have the following code:

Please Login or Register  to view this content.

Everything works as it should be (Opening the source file and get lr/ii) until the red line at the end, here VBA is showing the error "Application-defined or object-defined error".
In the original code, I have defined the range of the Vlookup with variables (SourceBlatt/SourceFile), as this was not working I now even used the actual file names, but there still seems to be a problem.

Any hints from your side would be highly appreciated.
Thank you very much in advance!

BR

[6StringJazzer]

File "MBR-02AA_Ressources_Plants_2022_BaPAA_20220503_1500.xlsx" must be open for this to work and I see nothing in your code that opens that file. Further you define the variable wbkSource but it is never again referenced.

[VBA Newbie1]

The file is open, but still does not seem to work. The file is getting opened by "Workbooks.Open (SourceFile) and this part of the code works perfectly fine, just the line with the Vlookup does not seem to work for some reason. You are right with the variable, I will delete it.

[6StringJazzer]

Please Login or Register  to view this content.

Is that not your real code?

[VBA Newbie1]

Instead of "Link to Sharepont", it is an actual link to the file, I should have made that clear in my comment