View original (French)

Import Excel data to another Excel file

Jean-Baptiste91 Posted messages 4 Status Member -  
Captain_Dunliver Posted messages 4 Status Member -
Hello,

I have two Excel files: Machin and Truc. What I would like to do is import the data from cell A1 of the Machin file to cell A1 of my second Excel file Truc. How could I achieve this with a macro, because I'm stuck on the code?

Thank you in advance.

3 answers

  1.
    Jean-Baptiste91 Posted messages 4 Status Member 11
     
    Sure, it works!

    Otherwise, to avoid having to type "=" and select the relevant cell and hit enter, is there a way to automate this when data is entered in cell A1 of my Machin file? A macro?
    10