Write On EXCEL Page 2

[acwoo1]

Hi

cName = "socie"
oExcel:Sheets( cName ):Select()
oSheet:Cells( 1, 1 ):Value="ABC"

cName = "socif"
oExcel:Sheets( cName ):Select()
oSheet:Cells( 1, 1 ):Value="BCD"

Only page 1 is updated.
Page 2 is not updated.
how to update two pages.

Thanks

ACWoo
Using FWH + bcc582

[Enrico Maria Giordano]

It should work. Please show a little sample that can be compiled and run, with the Excel file included.

EMG

[hua]

After you activate the other sheet did you reassign oSheet with the new active sheet?

[Enrico Maria Giordano]

Right, that could be the problem.

EMG

[acwoo1]

Thanks

It works.

Regards

AC Woo