Copy process result from one file to another

Originally Posted by snb

Please Login or Register  to view this content.

Hi,

Thank you for this reply.

Could you please explain me the action of this code as I'm new in macro?
When I run it, i get the result in file2.xls instead of in workbook wb1 as I mentioned in my previous post. The column is correct but not in the right workbook.
Also the result value is wrong, instead of 11581 I got 40603, where is the criteria inside the COUNTIFS of my code?
How to do to put the code inside grey space as yours in this forum?
Excuse me for this too many question!

Hary.

Hi,

Any help please?

Thanks in advance.
Hary.

Hi,

I need help from someone who can resolve my problem.
Please, share me your knowledge as i'm new with excel macro.

Thanks in advance.
Hary.

Originally Posted by pike

Hi hary.mada

The formula in R1C1 would be

Please Login or Register  to view this content.

Hi Pike,

Thank you for your reply.

Here is my code using your proposition:

Please Login or Register  to view this content.

but when I run it, File2.xls is open first by the programm then it ask me also to browse the excel file.
when I choose File2.xls, it ask me to pricise also the worksheet and at the end I got:

Please Login or Register  to view this content.

in the cell for result instead of number.
Could you help please what's wrong with my code?

Thanks in advance.
Hary.

Originally Posted by pike

you will need to use
COUNTIFS([FILE2.xls]Sheet1!R12C3,""TEXT1
not =NB.SI([WSSub]Sheet!$C$12;"ESME to MS")

Hi,

I got "execution error 1004" when I use:

Please Login or Register  to view this content.

I use above code instead of below code in order to simplify the problem

Please Login or Register  to view this content.

Just for your information, following code:

Please Login or Register  to view this content.

is the result of the process inside the cell of result and my MS Excel is French version, it's why I got =NB.SI

I think the code:

Please Login or Register  to view this content.

is fine but why I can't get the necessary value

Regards.
Hary.

Originally Posted by snb

Why didn't you analyse the code I suggested and why didn't you adapt it to your needs ?

Please Login or Register  to view this content.

Meanwhile I dissect your code, I propose you to find here below the code I used currently for this object after many surfing on the net. It's working fine but may be you have a best way to write it instead of mine:

Please Login or Register  to view this content.

However, many thanks for all peoples who tried to help and to support me. My macro learning with Excel is progressing slowly.

Hary.