Copying files using VBA in excel

[MarkoFOX]

Hello to everyone. I have a problem, it is so urgent, and i didn't know whom to address to. I am trying to create macro which will open excel file, have the ability to select the sheet of that excel file (final user to have that ability), copy value from that sheet and paste that value to a sheet of another excel file.

I have programed couple of codes but nothing works. One of the codes:



This code allows me to select which excel file to open and sheet to chose. Copies value but paste 0.00. I don't know why.


Good people, please help.

 

[Hui]

Is it possible that E31 has a value like 0 or 0.0000001 which is rounded to zero?

can you attached the file ?

 

[MarkoFOX]

Hui, thanks for answering so quickly. Tables are in my native language. Value is formula, but even tough i input random number it still paste 0.00. I will upload tables. I am trying to copy value from table 2 to table 1 (if you understand what i am trying to do).