| View previous topic :: View next topic |
| Author |
Message |
weezer
General User
Joined: 05 May 2003
Posts: 8
|
 Posted: Mon Jun 30, 2003 2:15 am Post subject: moving the cursor between sheets? |
 |
|
Hi folks,
i am still trying to export a my whole sdc file as cvs files (sheet per sheet).
By now I am looking for a service which moves my cursor to the next sheet?
And i dont know what kind of object I have to iniate?
This one does not work:
| Code: |
...
sheeti = thiscomponent.sheets(i)
startcell = sheeti.gotocell ("A1")
|
both var have been dim as object.
thanx again for any hint
w |
|
| Back to top |
|
 |
dfrench
Moderator
Joined: 03 Mar 2003
Posts: 1605
Location: Wellington, New Zealand
|
| Posted: Mon Jun 30, 2003 2:51 am Post subject: |
|
|
| Code: |
i=0
while i < thiscomponent.sheets.count()
oSheet = thiscomponent.sheets(i)
'do something with oSheet object eg
oCell=oSheet.getcellbyposition(0,0)
i=i+1
wend
|
and read the starbasic programmer tutorial |
|
| Back to top |
|
|
|
