Search found 6 matches

by ozboomer
Tue Feb 25, 2025 12:03 pm
Forum: PlanMaker NX and 2024 for Windows
Topic: Why has DateDiff been removed?
Replies: 0
Views: 9714

Why has DateDiff been removed?

Hi, all... Consider this simple code: ' ' Works Ok in BasicMaker Professional 2021 (rev S1068.1105) 32bit under Windows 8.1 32-bit ' DateDiff is unknown in BasicMaker Professional 2024 (rev S1222.1129) 64bit under Windows 11 64-bit ' Dim TheDate As Date ' Declare variables. Dim Msg TheDate = InputBo...
by ozboomer
Fri Nov 01, 2024 10:04 am
Forum: BasicMaker 2021 for Windows
Topic: Can BM dialogs be made to always appear in front of PM/TM?
Replies: 1
Views: 10878

Re: Can BM dialogs be made to always appear in front of PM/TM?

Edit: Nope, it doesn't work reliably. Dang. I've found one workaround... in that if you change the state of the application window before you display the Dialog, the Dialog is displayed in front of the application window. So, some code might be: ' Ensure PlanMaker is running Set pm = CreateObject(&...
by ozboomer
Fri Nov 01, 2024 8:26 am
Forum: BasicMaker 2021 for Windows
Topic: Can I determine the filespec of the running script file from within the script?
Replies: 0
Views: 8423

Can I determine the filespec of the running script file from within the script?

When running a batch file ( .bat ) in the command prompt ( cmd.exe ) in Windoze, I'm able to determine the filespec of the running batch file, viz:- e:\tmp> e:\tmp>cd E:\tmp e:\tmp>type test.bat @echo off echo filespec: %~dp0%~nx0 e:\tmp> e:\tmp>test.bat filespec: E:\tmp\test.bat e:\tmp> Is there a ...
by ozboomer
Thu Oct 31, 2024 1:44 pm
Forum: BasicMaker 2021 for Windows
Topic: Can BM dialogs be made to always appear in front of PM/TM?
Replies: 1
Views: 10878

Can BM dialogs be made to always appear in front of PM/TM?

Hi, again... I am setting up an application (PlanMaker in this case) using CreateObject() , etc... and I use the methods pm.Visible and pm.Active to ensure the user can see the application. If I then display a dialog, there doesn't seem to be any guarantee that the dialog will be displayed in front ...
by ozboomer
Tue Oct 29, 2024 11:28 pm
Forum: BasicMaker 2021 for Windows
Topic: How can I display script progress?
Replies: 0
Views: 9229

How can I display script progress?

Hi, again... When processing a PlanMaker worksheet that is complex or has many rows/columns to iterate through, the processing can take significant time. Is there any way that a 'progress' indicator... or some 'messasge' system be used to indicate progress? MsgBox() and Dialog() both need to be ackn...
by ozboomer
Sun Dec 10, 2023 12:45 pm
Forum: BasicMaker 2021 for Windows
Topic: Simple Question: How to locate the last populated cell in a column of a PlanMaker worksheet?
Replies: 2
Views: 31554

Simple Question: How to locate the last populated cell in a column of a PlanMaker worksheet?

Hi, all... another newbie here (in BasicMaker, anyway)... and I haven't done any VBA-style things in a spreadsheet since the 1990s or something(!) So, a bit of a simplistic question: I have a worksheet that has a title row and then some populated rows. I simply want to find the last non-empty row in...

Go to advanced search