Copy from one workbook to another workbook.

Please Login or Register  to view this content.

I am using the code above to copy a range of cells from workbook wbSatai to workbook wbShori. It works fine but the problem is that from wbSatai the copied cells has lots of merged cells but when pasted to wbShori the cells are unmerged. Another thing is that one column in wbSatai is of percentage format. The original values are something like 69.12541254 but what you see on the workbook is 69.13% now the problem is that when I pasted it on wbShori the value becomes 69.13 with a little green arrow on the side. I know there is not much changed but the thing is that I will be using the pasted values to another worksheet on wbShori so to get the exact value is very important. How can I copy and paste the values to another sheet and make the format and values the same. I thought xlPasteAll should have done the work but its not working.

The 2 workbooks has the same filename but is located on a different folder so I cant open them simultaneously and do the comparison. Any help would be greatly appreciated. What am I doing wrong.

Hi dave.
I think that should have work but the 2 workbooks have the same filename so I can't open them simultaneously it results to error.

Still gives the same result. I'm stock with this one since yesterday.　（TT_TT）

Gives a runtime error...1004
on the line with mergearea.

on the wbSatai workbook I uploaded I need to copy
the values on Range("H8:Y37")

the copied range should be pasted to wbShori workbook
and hopefully retain the values as well as the formats
but then as you can see on the wbShori I uploaded
the pasted values Range("H40:Y69") somehow didnt retain
the format...whats even worse is on the third column
where the values are on percentage(%) the values are rounded up (ex. 22.125463541%--->22.22%)

I needed the exact value because I need to compare those
values if it is equal to the values on Range("H8:Y37") of wbShori.

wbSatai's filename and wbShori's filename is sometimes the same
that is why I can't open them at the same time
to do the comparison. That's why I made it
copy from wbsatai --->paste to wbShori --> do the comparison

Thank you very much dave.

Anybody who knows how to solve this?

I also get error when I use

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

but I don't get and error when I use this,

Please Login or Register  to view this content.

However, the pasted values are still wrong..It doesnt copy the exact values instead the rounded up values and
there are still green triangles on the side which meant that it encounters error when pasted.