vba code from closed workbook to update active sheet not working as requested

I have a database workbook on C:\Users\user\documents which is always close.

The active sheet has the following code to update column C and D of invoice workbook which is the active sheet.

But on trigger , I am getting an open dialog box with update values looking for the file , each time I pressed the cancel key of dialog box, it updates one cell , the dialog box open , press cancel it update one cell by one cell.

Can anyone assist

Please Login or Register  to view this content.

Try change to

Please Login or Register  to view this content.

Thank you JINDON

Works as requested