Hi All ,

I am not sure if this is the correct group or not to ask
this question , If not , I apologize in advance.

I have a Question regarding addition of WorkSheets of one
Excel Application into the other Master Excel Application. If anybody
knows the Answer - You are Welcome.

Question : How to add a Excel WorkSheet of one Excel
Application into the other Excel Application ( I know that there is a
way to consider Range of cells and to proceed , but I can't do that
since I am not aware of how many cells are filled with data in the
first source sheet) . In summary, I need to create master Excel
Application that consists of the sheets of different individual Excel
Applications ( In VB ).

Thanks In Advance,

I don't think you can copy a worksheet across instances of excel - however
you can open the all the workbooks you want in the same instance of excel
and then copy the sheet that way

With Workbooks("Master.xls")
Activeworkbooks.worksheets(1).Copy _
After:=.Worksheets(.Worksheets.count)
End With

--
Regards,
Tom Ogilvy


"Excel" wrote in message
oups.com...
Hi All ,

I am not sure if this is the correct group or not to ask
this question , If not , I apologize in advance.

I have a Question regarding addition of WorkSheets of one
Excel Application into the other Master Excel Application. If anybody
knows the Answer - You are Welcome.

Question : How to add a Excel WorkSheet of one Excel
Application into the other Excel Application ( I know that there is a
way to consider Range of cells and to proceed , but I can't do that
since I am not aware of how many cells are filled with data in the
first source sheet) . In summary, I need to create master Excel
Application that consists of the sheets of different individual Excel
Applications ( In VB ).

Thanks In Advance,