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

When you do this manually, how do you find the used range?

If you locate it yourself, maybe you're not doing the same thing that excel
does.

ctrl-end will take to you the last used cell.

If that's way past what you expect, maybe a visit to Debra Dalgleish's site will
help:

http://www.contextures.com/xlfaqApp.html#Unused

(She has some code there that you may want to incorporate into your macro.)

dude wrote:

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

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

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

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

Thanks.

--
dude
------------------------------------------------------------------------
dude's Profile: http://www.excelforum.com/member.php...o&userid=15315
View this thread: http://www.excelforum.com/showthread...hreadid=269372

--

Dave Peterson