CreateObject now not working

Post Reply
enonod
Posts: 38
Joined: Tue Nov 08, 2016 1:54 pm

CreateObject now not working

Post by enonod » Mon Jun 15, 2020 7:35 pm

PlanMaker Professional 2021 (rev S1014.0529) 64bit
Windows 10

The following worked fine until I stated using 2021.

Dim pm as Object
Set pm = CreateObject("PlanMaker.Application")
pm.Visible = True

It now fails on Set pm...
ActiveX component can't create object.

Can you advise please.

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

Re: CreateObject now not working

Post by SuperTech » Tue Jun 16, 2020 12:37 am

Thanks for reporting this problem. I tried to run this code from BasicMaker and TextMaker and it worked well. Please share a screenshot of the error you are getting in this code.

enonod
Posts: 38
Joined: Tue Nov 08, 2016 1:54 pm

Re: CreateObject now not working

Post by enonod » Wed Jun 17, 2020 5:42 pm

Thank you for your response and I attach the error picture.
I must emphasise that nothing has changed on my computer and I have not edited or changed the BasicMaker script, I simply installed the v2021 when I purchased it and ran my accounts as normal only to have it fail as described.
Attachments
Error5.png

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

Re: CreateObject now not working

Post by SuperTech » Wed Jun 17, 2020 7:36 pm

Thanks for sharing the screenshot. I was unable to reproduce this problem but I have forwarded the details to our development team. Meanwhile, please share the script file which you are trying to run.

enonod
Posts: 38
Joined: Tue Nov 08, 2016 1:54 pm

Re: CreateObject now not working

Post by enonod » Wed Jun 17, 2020 8:23 pm

Thank you again.
I attach the program (in use since early 2019, but have for this copy had to alter text in "" only because this is my accounts.
Attachments
Update.bas
(8.59 KiB) Downloaded 24 times

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

Re: CreateObject now not working

Post by martin-k » Wed Jun 17, 2020 8:27 pm

Does it work if you start PlanMaker manually beforehand?
Martin Kotulla
SoftMaker Software GmbH

enonod
Posts: 38
Joined: Tue Nov 08, 2016 1:54 pm

Re: CreateObject now not working

Post by enonod » Thu Jun 18, 2020 5:42 pm

I always start Planmaker and load the spreadsheet and at some stage (dependent on what I enter) will run the script.

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

Re: CreateObject now not working

Post by martin-k » Thu Jun 18, 2020 5:45 pm

1. Ensure that the file PlanMaker.tlb exists in Program Files\SoftMaker Office 2021.
2. Reinstall SoftMaker Office. Maybe something has messed up the registry settings.
Martin Kotulla
SoftMaker Software GmbH

enonod
Posts: 38
Joined: Tue Nov 08, 2016 1:54 pm

Re: CreateObject now not working

Post by enonod » Thu Jun 18, 2020 6:00 pm

While I am doing that perhaps I should mention that I am running Office as a portable, produced in the proper way.
The original has been uninstalled.
I will of course re-install but the indication is that it would not therefore be a registry issue.
EDIT: The tlb file is present.

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

Re: CreateObject now not working

Post by martin-k » Thu Jun 18, 2020 6:01 pm

Oh, that won't work. For OLE Automation to work, it needs to be properly installed in the Windows Registry. Portable apps don't do that.
Martin Kotulla
SoftMaker Software GmbH

enonod
Posts: 38
Joined: Tue Nov 08, 2016 1:54 pm

Re: CreateObject now not working

Post by enonod » Thu Jun 18, 2020 6:03 pm

Ah! That would have been nice to know.
I will install and presume it will work and I will report back.
Sorry I did not think there was any difference.

enonod
Posts: 38
Joined: Tue Nov 08, 2016 1:54 pm

Re: CreateObject now not working

Post by enonod » Thu Jun 18, 2020 6:15 pm

Thank you very much martin-k, all is now well.
What I find very odd is that with v2018 I used it as a portable in a folder on the computer with no problem.
Kind regards

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

Re: CreateObject now not working

Post by martin-k » Thu Jun 18, 2020 6:38 pm

Most likely this was so because your regular install created the registry entries, and since portable PlanMaker was already running, BasicMaker switched to it instead of starting the regulary installed version.
Martin Kotulla
SoftMaker Software GmbH

enonod
Posts: 38
Joined: Tue Nov 08, 2016 1:54 pm

Re: CreateObject now not working

Post by enonod » Thu Jun 18, 2020 7:48 pm

Thank you

Post Reply

Return to “BasicMaker 2021 for Windows”