Copy data from another file

[qiyusi]

Hello,

I am practising to copy data from another sheet (example: B.xlsx) then paste the data to current sheet (A.xlsm), do calculation,
the copy back the result to B.xlsx
below is code using macro recorder:

Please Login or Register  to view this content.

example file attached.

my questions:
- how to modify the code, with the condition, B.xlsx is not open yet.
- how to do same process for each cell in column A until last cell.
- how to save as A.xlsx with date addition.

Appreciate for any help.
Thank you.

[karedog]

5B:

Please Login or Register  to view this content.

[qiyusi]

Hi Karedog

Thank you for your help. The code works great!

so if i need to have the strFile="B.xlsx" became dynamic, so we can select the file using dialog box.

what to modify from code below?

Please Login or Register  to view this content.

[karedog]

Like this ?

Please Login or Register  to view this content.

[qiyusi]

Hi,

Sorry for late reply.

The code works great! Thank you very much.