To Copy ranges from multiple workbooks to one sheet

[psmcltraining]

The code below copies range "e11,i11,m11,a15,f15,k15,a19,a20,b21,b22,f19,f20,g21,g22,m19,m20,m21,l22,c25,c26,c27,c28,h25,h26,h27,m25,m26,m27,a33:n37" from sheet named "form" of every workbook in the folder which I specify (through browse).And paste the data in the open workbook in sheet named "Data". It is ok and as per my requirement. But I want that instead of using sheet name "form" there should be sheet index i.e I want to copy data from sheet1 of every workbook instead of sheet name "Form" of every workbook in the specified folder, rest of the process is ok. This code 95% fits to my requirement except that I want to use sheet index instead of sheet name. I think something needs to be done with the line ShName = "Form".

Please Login or Register  to view this content.

[royUK]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

I will add them this time

[shasur]

Are you going to copy all sheets in the workbook or the first sheet alone

if it is firstsheet then you need to open the excel workbook JustFileName and get the sheet1's name :

Please Login or Register  to view this content.

[psmcltraining]

Thanks for the answer. I am no very familiar with Macros. Please tell me to how and where should I use this Code in my existing code.

Thanks