topic-35553

Posts: 175

Joined: Tue Nov 10, 2009 10:56 AM

Write On EXCEL Page 2
Posted: Wed Apr 25, 2018 12:20 PM

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

Posts: 9020

Joined: Thu Oct 06, 2005 08:17 PM

Re: Write On EXCEL Page 2
Posted: Wed Apr 25, 2018 02:54 PM

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

EMG

Posts: 1096

Joined: Fri Oct 28, 2005 02:27 AM

Re: Write On EXCEL Page 2
Posted: Wed Apr 25, 2018 03:00 PM

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

FWH 11.08/FWH 19.12

BCC5.82/BCC7.3

xHarbour/Harbour

Posts: 9020

Joined: Thu Oct 06, 2005 08:17 PM

Re: Write On EXCEL Page 2
Posted: Wed Apr 25, 2018 03:04 PM

Right, that could be the problem.

EMG

Posts: 175

Joined: Tue Nov 10, 2009 10:56 AM

Re: Write On EXCEL Page 2
Posted: Thu Apr 26, 2018 05:02 AM

Thanks

It works.

Regards

AC Woo

FiveTech Support Forums