I have this macro that opens a specified excel file (a large one) i
order to import information from it to another excel.

To import the information I use the copy usedarea function and paste i
as values in the target.

For some reason this macro results in my target file becoming hug
(lots of MB). When I try doing the same procedure manually (copy rang
- paste special values. The result is different and does not import an
access MBs.

Is there a way to import data in the minimum storage capacity?

Thanks

--
dud
-----------------------------------------------------------------------
dude's Profile: http://www.excelforum.com/member.php...fo&userid=1531
View this thread: http://www.excelforum.com/showthread.php?threadid=26937