Hello, if someone can Help...
so far I can write on a sheet a Data and in final on Close the PlanMaker shaw up quest about if I want to save the untitled 1 file and what Name I want to give... Buy the way This is not a Automation; I go in PlanMaker and I can in 1 minut creat a file and seve them.
Hire what I do : I start with a piece of code find in Manual:
Dim pm as Object
Dim newDoc as Object
Dim newSheet as Object
Set pm = CreateObject("PlanMaker.Application")
Set newDoc = pm.Workbooks.Add
Set newSheet = newDoc.Sheets.Add("test")
HERE I change test with the name that I whant: EX: Set newSheet = newDoc.Sheets.Add("Test" &gFixNr$ &"R" &UpDateDate$ &".pmdx")
I do my Program...
In final I don't find the code to Save on disk... with all try
So the final:
pm.Application.Quit
Set pm = Nothing
Shaw up PM whit the possibility to NAME the untitled file and Save ( in the file on the bassement stay the NAME of the sheet :"Test" &gFixNr$ &"R" &UpDateDate$ &".pmdx" BUT the Plan Maker file is Untitlet 1 or 2...
Thanks for some resolutions! Gimy
'-----------------------------------------------------
Hello, here I try to resolve this myself:
The first Obstacle is that the File I want to create have some data in his name ( Client Nr. and date ).
So I pass this by create the File before the activation of the BasicMaker automation that I do.
Here is the result :
'===========================================================
' OPEN A File and Update them - PlanMaker SHEET
'-----------------------------------------------------------
Dim FName As String
Dim row, col as Integer
row = 1 : col = 1
'FName$ = "c:\abc\Test\" &gFixNr &dUpdate &"R" &".pmdx"
' was not posible that is a File.Add
' the File FName$ must exist on Disk , so the File will be
FName$ = "c:\abc\Test\CLI758REuz.pmdx"
'=============================================
Dim pm as Object
Set pm = CreateObject("PlanMaker.Application")
pm.Application.RecentFiles.Add FName$
pm.Workbooks.Open FName$
'=============================================
...
row = 1
...
'================ Update ROW in Worksheet ====
' row 1, is the FrontName on the Sheet
row = row + 1
For col = 1 to 13
pm.Cells.Item(row, col).Value = XYZ$(col - 1)
Next col
'=============================================
...
' Final
pm.Workbooks(FName$).Save
pm.Application.Quit
Set pm = Nothing
' Salutations from Gimy Bucharest
How to create pmdx File en BasicMaker end save Automate on Disk
Post Reply
1 post
• Page 1 of 1
Return to “BasicMaker 2021 for Windows”
Jump to
- SoftMaker Office NX and 2024
- ↳ SoftMaker Office NX and 2024 for Windows
- ↳ SoftMaker Office NX and 2024 for Windows (General)
- ↳ TextMaker NX and 2024 for Windows
- ↳ PlanMaker NX and 2024 for Windows
- ↳ Presentations NX and 2024 for Windows
- ↳ BasicMaker NX and 2024 for Windows
- ↳ SoftMaker Office NX and 2024 for Mac
- ↳ SoftMaker Office NX and 2024 for Mac (General)
- ↳ TextMaker NX and 2024 for Mac
- ↳ PlanMaker NX and 2024 for Mac
- ↳ Presentations NX and 2024 for Mac
- ↳ SoftMaker Office NX and 2024 for Linux
- ↳ SoftMaker Office NX and 2024 for Linux (General)
- ↳ TextMaker NX and 2024 for Linux
- ↳ PlanMaker NX and 2024 for Linux
- ↳ Presentations NX and 2024 for Linux
- ↳ SoftMaker Office NX for iOS
- ↳ SoftMaker Office NX for iOS (General)
- ↳ TextMaker NX for iOS
- ↳ PlanMaker NX for iOS
- ↳ Presentations NX for iOS
- ↳ SoftMaker Office NX for Android
- ↳ SoftMaker Office NX for Android (General)
- ↳ TextMaker NX for Android
- ↳ PlanMaker NX for Android
- ↳ Presentations NX for Android
- SoftMaker Office 2021
- ↳ SoftMaker Office 2021 for Windows
- ↳ SoftMaker Office 2021 for Windows (General)
- ↳ TextMaker 2021 for Windows
- ↳ PlanMaker 2021 for Windows
- ↳ Presentations 2021 for Windows
- ↳ BasicMaker 2021 for Windows
- ↳ SoftMaker Office 2021 for Mac
- ↳ SoftMaker Office 2021 for Mac (General)
- ↳ TextMaker 2021 for Mac
- ↳ PlanMaker 2021 for Mac
- ↳ Presentations 2021 for Mac
- ↳ SoftMaker Office 2021 for Linux
- ↳ SoftMaker Office 2021 for Linux (General)
- ↳ TextMaker 2021 for Linux
- ↳ PlanMaker 2021 for Linux
- ↳ Presentations 2021 for Linux
- FreeOffice 2024
- ↳ FreeOffice 2024 for Windows
- ↳ FreeOffice 2024 for Windows (General)
- ↳ FreeOffice TextMaker 2024 for Windows
- ↳ FreeOffice PlanMaker 2024 for Windows
- ↳ FreeOffice Presentations 2024 for Windows
- ↳ FreeOffice 2024 for Mac
- ↳ FreeOffice 2024 for Mac (General)
- ↳ FreeOffice TextMaker 2024 for Mac
- ↳ FreeOffice PlanMaker 2024 for Mac
- ↳ FreeOffice Presentations 2024 for Mac
- ↳ FreeOffice 2024 for Linux
- ↳ FreeOffice 2024 for Linux (General)
- ↳ FreeOffice TextMaker 2024 for Linux
- ↳ FreeOffice PlanMaker 2024 for Linux
- ↳ FreeOffice Presentations 2024 for Linux
- ↳ FlexiPDF NX and 2025 for Windows
- ↳ FreePDF 2025 for Windows
- Miscellaneous
- ↳ SoftMaker Fonts
- ↳ Water Cooler
- ↳ SoftMaker Office 2018 for Windows (General)
- ↳ TextMaker 2018 for Windows
- ↳ PlanMaker 2018 for Windows
- ↳ Presentations 2018 for Windows
- ↳ Thunderbird for Windows
- ↳ BasicMaker 2018 for Windows
- ↳ SoftMaker Office 2018 for Mac (General)
- ↳ TextMaker 2018 for Mac
- ↳ PlanMaker 2018 for Mac
- ↳ Presentations 2018 for Mac
- ↳ SoftMaker Office 2018 for Linux (General)
- ↳ TextMaker 2018 for Linux
- ↳ PlanMaker 2018 for Linux
- ↳ Presentations 2018 for Linux
- ↳ SoftMaker Office 2021 for Android
- ↳ SoftMaker Office 2021 for Android (General)
- ↳ TextMaker 2021 for Android
- ↳ PlanMaker 2021 for Android
- ↳ Presentations 2021 for Android
- ↳ SoftMaker Office 2021 for iOS
- ↳ General
- ↳ TextMaker 2021 for iOS
- ↳ PlanMaker 2021 for iOS
- ↳ Presentations 2021 for iOS
- ↳ FreeOffice 2021
- ↳ FreeOffice 2021 for Windows
- ↳ FreeOffice 2021 for Windows (General)
- ↳ FreeOffice TextMaker 2021 for Windows
- ↳ FreeOffice PlanMaker 2021 for Windows
- ↳ FreeOffice Presentations 2021 for Windows
- ↳ FreeOffice 2021 for Mac
- ↳ FreeOffice 2021 for Mac (General)
- ↳ FreeOffice TextMaker 2021 for Mac
- ↳ FreeOffice PlanMaker 2021 for Mac
- ↳ FreeOffice Presentations 2021 for Mac
- ↳ FreeOffice 2021 for Linux
- ↳ FreeOffice 2021 for Linux (General)
- ↳ FreeOffice TextMaker 2021 for Linux
- ↳ FreeOffice PlanMaker 2021 for Linux
- ↳ FreeOffice Presentations 2021 for Linux
- ↳ BETA SoftMaker Office 2024 for Windows
- ↳ BETA SoftMaker Office 2024 for Windows (general)
- ↳ BETA TextMaker 2024 for Windows
- ↳ BETA PlanMaker 2024 for Windows
- ↳ BETA Presentations 2024 for Windows
- ↳ BETA BasicMaker 2024 for Windows
- ↳ BETA SoftMaker Office 2024 for Mac
- ↳ BETA SoftMaker Office 2024 for Mac (general)
- ↳ BETA TextMaker 2024 for Mac
- ↳ BETA PlanMaker 2024 for Mac
- ↳ BETA Presentations 2024 for Mac
- ↳ BETA SoftMaker Office 2024 for Linux
- ↳ BETA SoftMaker Office 2024 for Linux (general)
- ↳ BETA TextMaker 2024 for Linux
- ↳ BETA PlanMaker 2024 for Linux
- ↳ BETA Presentations 2024 for Linux
- ↳ BETA SoftMaker Office NX for Android
- ↳ BETA SoftMaker Office NX for Android (general)
- ↳ BETA TextMaker NX for Android
- ↳ BETA PlanMaker NX for Android
- ↳ BETA Presentations NX for Android
- ↳ BETA SoftMaker Office NX for iOS
- ↳ BETA SoftMaker Office NX for iOS (general)
- ↳ BETA TextMaker NX for iOS
- ↳ BETA PlanMaker NX for iOS
- ↳ BETA Presentations NX for iOS
- ↳ FreePDF 2022
- ↳ FlexiPDF 2022