merging multiple spreadsheets

[stevewebs]

Hi, This is my first post.

I have roughly 2700 files which I need to merge into one, please can somebody tell me if this is possible using certain code?

The size of the files range from 1kb to around 43kb so they are not massive files.

Would it be possible for all the information to be merged into the same sheet or will it be different sheets?

The maximum amount of cells which are populated in the spreadsheets are coulmn A going down to row 802

Thanks in advance for any replies.

Steve

 

[VoG]

See if this helps http://msdn.microsoft.com/en-us/library/cc837974.aspx