Hello,
I want to open 2 workbook, , lets say workbook1 and workbook2
now I want to copy data from a sheet name "TEST" in workbook2 and paste the
data to a sheet named "TEST" in workbook.
now , I dont know the size of the data ,so I can't use the get_range option
of the c# . I need a command like select.currentregion of the vba.
antoher problem that I have is that I can't open 2 workbook with the
Excel.Application:
Excel.Application oXL;
Excel.Workbook Wxls =
oXL.Workbooks.Open(wfile,
Type.Missing, Type.Missing, Type.Missing,
Type.Missing,
Type.Missing, Type.Missing, Type.Missing,
Type.Missing,
Type.Missing, Type.Missing, Type.Missing,
Type.Missing,
Type.Missing, Type.Missing);
Excel.Workbook Wxls2 =
oXL.Workbooks.Open(wfile2,
Type.Missing, Type.Missing, Type.Missing,
Type.Missing,
Type.Missing, Type.Missing, Type.Missing,
Type.Missing,
Type.Missing, Type.Missing, Type.Missing,
Type.Missing,
Type.Missing, Type.Missing);
mybe my syntax is not good.
So, Does anyone know how to do this?
Thanks,
Eyal