open worksheets of unknown count in same workbook

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

open worksheets of unknown count in same workbook

Post by Princy557 » Tue Aug 18, 2020 11:59 am

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: 1415
Joined: Wed Mar 11, 2020 5:31 pm

Re: open worksheets of unknown count in same workbook

Post by SuperTech » Tue Aug 18, 2020 2:51 pm

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: 168
Joined: Wed May 18, 2011 10:32 am

Re: open worksheets of unknown count in same workbook

Post by Princy557 » Tue Aug 18, 2020 9:40 pm

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: 2875
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 » Tue Aug 18, 2020 9:49 pm

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: 168
Joined: Wed May 18, 2011 10:32 am

Re: open worksheets of unknown count in same workbook

Post by Princy557 » Wed Aug 19, 2020 10:11 pm

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

Princy557

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

Re: open worksheets of unknown count in same workbook

Post by Princy557 » Tue Sep 29, 2020 8:21 pm

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”