Search found 116 matches

by Princy557
Tue Sep 17, 2019 3:10 pm
Forum: BasicMaker 2018 for Windows
Topic: BasicMaker enhancements - Are there any in pipeling?
Replies: 3
Views: 8074

BasicMaker enhancements - Are there any in pipeling?

Hi,
Just a thought. Are there any enhancements due to be updated in BasicMaker software package?

In the existing .pdf file it also intimates that there are improvements to the manual on their way. Is that happening?
by Princy557
Fri Sep 13, 2019 2:49 pm
Forum: BasicMaker 2018 for Windows
Topic: call .bas to read a cell and write in another two.
Replies: 8
Views: 9179

Re: call .bas to read a cell and write in another two.

Hi, Can I ask one more thing on this very educational thread... I have a 'BlankInvoice' worksheet. How do I copy it in its entirety How do I copy it to the right (of the BlankInvoice), with the new invoice number just created prior in this thread. I'm finding things difficult to follow in the .pdf d...
by Princy557
Thu Sep 12, 2019 9:33 am
Forum: BasicMaker 2018 for Windows
Topic: call .bas to read a cell and write in another two.
Replies: 8
Views: 9179

Re: call .bas to read a cell and write in another two.

Hi elmonopascual,
Thank you for that it works a treat, obviously I had to modify it slightly for my personal use. But it is really useful to me. Thanks again. :D
by Princy557
Wed Sep 11, 2019 9:51 pm
Forum: BasicMaker 2018 for Windows
Topic: call .bas to read a cell and write in another two.
Replies: 8
Views: 9179

Re: call .bas to read a cell and write in another two.

Hi again
Can I be cheeky and ask how that would work with a date?
How do I read a date and put say todays date back into another cell?
by Princy557
Wed Sep 11, 2019 9:50 pm
Forum: BasicMaker 2018 for Windows
Topic: call .bas to read a cell and write in another two.
Replies: 8
Views: 9179

Re: call .bas to read a cell and write in another two.

Hi again
Can I be cheeky and ask how that would work with a date?
How do I read a date and put say todays date back into another cell?
by Princy557
Wed Sep 11, 2019 9:47 pm
Forum: BasicMaker 2018 for Windows
Topic: call .bas to read a cell and write in another two.
Replies: 8
Views: 9179

Re: call .bas to read a cell and write in another two.

Hi,
Sorry for delay, got caught up in family stuff.
Thanks for the reply I'll try it this evening and hopefully learn something as well.
Cheers for you help.
by Princy557
Mon Sep 09, 2019 11:21 pm
Forum: PlanMaker 2018 for Windows
Topic: How to see two worksheets of the same document at the same file
Replies: 6
Views: 6693

Re: How to see two worksheets of the same document at the same file

HI Jossi,
Did not realize he wanted to synchronize the files just to look at them.
by Princy557
Mon Sep 09, 2019 11:19 pm
Forum: BasicMaker 2018 for Windows
Topic: writing a date into a cell
Replies: 2
Views: 9076

writing a date into a cell

Hi,
sorry me again. :o

One other thing I can't find in the manual is how to write a date into a cell or reading it for that matter.

I've managed the writing and reading of values and text into and out of cells.
by Princy557
Sat Sep 07, 2019 11:34 am
Forum: PlanMaker 2018 for Windows
Topic: How to see two worksheets of the same document at the same file
Replies: 6
Views: 6693

Re: How to see two worksheets of the same document at the same file

duplicate the working file as filename_copy
Open them both.

I am making the assumption that only one file will be changed (the master)??
It was just a though that might have worked.
by Princy557
Sat Sep 07, 2019 10:41 am
Forum: PlanMaker 2018 for Windows
Topic: How to see two worksheets of the same document at the same file
Replies: 6
Views: 6693

Re: How to see two worksheets of the same document at the same file

Hi
Does View | Windows | Side by side work
Regards Princy557
by Princy557
Thu Sep 05, 2019 10:25 pm
Forum: BasicMaker 2018 for Windows
Topic: call .bas to read a cell and write in another two.
Replies: 8
Views: 9179

Re: call .bas to read a cell and write in another two.

Hi
Getting nowhere on this....

How do I pass a value (based on a cell value) to BasicMaker code and return another back to planmaker.
by Princy557
Tue Sep 03, 2019 3:45 pm
Forum: BasicMaker 2018 for Windows
Topic: call .bas to read a cell and write in another two.
Replies: 8
Views: 9179

call .bas to read a cell and write in another two.

HI
Using basic maker, how do I open a worksheet and read two numbers from particular two cells.
Then write back to those cells new information?

I hope to run it from a planmaker button.

Regards Princy557 :)
by Princy557
Tue Sep 03, 2019 3:24 pm
Forum: PlanMaker 2018 for Windows
Topic: Activate script via a button - is it going to happen?
Replies: 8
Views: 9045

Re: Activate script via a button - is it going to happen?

Hi martin,
Just as a follow up, now finding some of the answers I could not find in an 'old' .pdf.
Struggling now to work out how to action a button to open and read a cell, then to write back another value.
Keeps me off the streets ha ha.
Regards Princy557 :lol:
by Princy557
Tue Sep 03, 2019 3:21 pm
Forum: PlanMaker 2018 for Windows
Topic: Remove #N/A
Replies: 2
Views: 3725

Re: Remove #N/A

Hi miguel-c

Works a treat thanks for the quick response.
Regards Princy 557
by Princy557
Tue Sep 03, 2019 12:38 pm
Forum: PlanMaker 2018 for Windows
Topic: Remove #N/A
Replies: 2
Views: 3725

Remove #N/A

HI,
how to remove the #N/A from a cell with this in it. (While it's empty)
=IF(LEN(VLOOKUP($C$6,'Customer List'!$A$2:$K$25,2,0))=0,"",VLOOKUP($C$6,'Customer List'!$A$2:$K$25,2,0))

Regards
Princy557 :?

Go to advanced search