Opening a workbook in macro first

[jeskit]

Hi

I am trying to work out how to get the piece of code below to open a excel workbook (Extract_Size_Checker_test.xls) from my documents first and put the results in that document in the dealer data sheet and in cell range F17:H38.

Please Login or Register  to view this content.

Can anyone please help me? as i have tried everything i know but nothing works without fail.

Thank you

Jeskit

[royUK]

Are you sure that you need VBA, you might be able to simply use VLOOKUP

[jeskit]

Hi

Even through that would make my life much easier. It has to be VBA macro.