open worksheets of unknown count in same workbook

Post Reply
User avatar
Princy557
Posts: 192
Joined: Wed May 18, 2011 10:32 am

open worksheets of unknown count in same workbook

Post by Princy557 »

HI,
How would I manage to open a list of x number of worksheets all in the same workbook, access a couple of fields and add them to a summary field on a new workbook.

The worksheets are going to be fixed format titles, such as Invoice 20200811-01, Invoice 20200812-02
How do I work out how many there are, or do I just scan in some way.
IS it possible, is it using Basic?

Any thoughts?
Regards
Regards

Princy557
SuperTech
SoftMaker Team
SoftMaker Team
Posts: 2933
Joined: Wed Mar 11, 2020 5:31 pm

Re: open worksheets of unknown count in same workbook

Post by SuperTech »

Yes, it is possible by using BasicMaker scripts. Please refer to the BasicMaker manual for the development of such a script to achieve this task.

Thanks
User avatar
Princy557
Posts: 192
Joined: Wed May 18, 2011 10:32 am

Re: open worksheets of unknown count in same workbook

Post by Princy557 »

HI Supertech,

Thanks, however I had hoped for a few more hints on the subject.
But never mind, thanks for responding
Regards

Princy557
martin-k
SoftMaker Team
SoftMaker Team
Posts: 3083
Joined: Fri Nov 21, 2003 4:57 pm
Location: Nürnberg, Germany
Contact:

Re: open worksheets of unknown count in same workbook

Post by martin-k »

Check out the "Worksheets" collection in the BasicMaker manual. It lets you enumerate all worksheets of a workbook.
Martin Kotulla
SoftMaker Software GmbH
User avatar
Princy557
Posts: 192
Joined: Wed May 18, 2011 10:32 am

Re: open worksheets of unknown count in same workbook

Post by Princy557 »

Thanks Martin-k
Will feedback later, sorry but probably with a follow up question.
Regards

Princy557
User avatar
Princy557
Posts: 192
Joined: Wed May 18, 2011 10:32 am

Re: open worksheets of unknown count in same workbook

Post by Princy557 »

Well I've pratted about for quite a few hours but up to now have not managed to so what I want.
If someone has the time to spend 10 minutes or what you can spare to tell how to do it please.
I have done nothing more that confuse myself with all this modern referencing and linking to other worksheets.
If you know please let me know.
I also need it to change a cell in the same row to the current date to indicate last time accessed.

Original Post was:
Princy557 wrote: Tue Aug 18, 2020 11:59 am How would I manage to open a list of x number of worksheets all in the same workbook, access a couple of fields and add them to a summary field on a new workbook.

The worksheets are going to be fixed format titles, such as Invoice 20200811-01, Invoice 20200812-02
How do I work out how many there are, or do I just scan in some way.
IS it possible, is it using Basic?
Regards

Princy557
Post Reply

Return to “PlanMaker 2021 for Windows”