how to copy data with out using paste method

[jaffar]

Hi,



We have 36 excel files, each excel file consists 9 sheets. The 36 excel
files are copy of the some excel file. In some sheets of excel files may
contain data and some may not contain data.



So in my main excel file I have written a macro which copies the data (my
macro wont copy whole sheet it copies data sheets which is having data in
the cells, if any row not containing any data then that row is not copied)
from all these 36 excel files into a new sheets of new workbook, for this I
have used

Paste special pate: = xlPasteValues etc.

This is working fine but I want to achieve exact functionality with out
using Paste methods, is it possible to do this requirement with out using
paste method? If yes can you tell me how to do this?



Are there any alternative methods?

 

[zaphod2003]

There is a way to do this but it's a tad messy.

What you could do is export the data to a text file and then read it
back again. However, could you explain why you don't want to use the
Paste function?

 

[jaffar]

hi zaphod,
Can you give me sample code for exporting data to text file
and get back.

Client told us, I need to avoid using the paste method as it has a limit of
255 characters, users may fill the "note " field with much more data that
255 characters.