FiveTech Software tech support forums

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

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

EMG

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

Right, that could be the problem.

EMG

Thanks

It works.

Regards

AC Woo