copying excel files

[iaaa99]

i have a huge number of excel files and i want to gather them in one excel file which contain sheets, and every sheet represnt one of the excel file , in other words for example if i have 10 files i want to have one excel file contain 10 sheets , is there any way to do that stuff else the copy paste way

 

[GeorgeAdamson]

I don't know if there's an efficient way of doing this but you could try recording a macro while you open one of your files and copy its contents into a new sheet. You could then run the macro on each file, or even modify it to work through a list of filenames.

G

 

[royUK]

How many sheets are used in each file?
If you want to copy one sheet from a file you can create a new file and leave it open. Then open each file and right click on the page tab to copy and choose copy sheet and choose your new file as the destination to copy to.

 

[iaaa99]

i have more than 1000 files which mean in copy paste it will take 2 -3 days
for macro way i did it but i tried to modify the macro so i can open the files in sequence but it dosenot work , can anyone help me telling me how in VB i can open an excel file have a string inside it for example test1.xls, test2.xls .....