hexagon logo

Scripting Help for auto Save-as

Trying to get going on some scripting and automation. Very new to this so any and all help most appreciated. The following code gives this error :

---------------------------
PC-DMIS Basic Scripting Engine
---------------------------
Error on line: 9 - OLE Automation object does not have a default value
---------------------------
OK
---------------------------

Can someone help me get this simple script running?

Sub Main ()
Dim App As Object
Dim Part As Object
Set App = CreateObject ("PCDLRN.Application")
Set Part = App.ActivePartProgram
Dim Serial As Object
Set Serial = Part.GetVariableValue("V1")
Dim NewName$
NewName = Part.Path & Part.PartName & "_" & Serial & ".PRG"
retval = Part.SaveAs(NewName)
' Cleanup
Set Part = Nothing
Set App = Nothing
End Sub


I believe this code was originally posted in a different (and probably much better) form by VPT.se. I'm trying to learn how to do this sort of thing by modifying it.

Thanks for any help.
Parents

  • Finally, what is the easiest way to make a script like this into an executable? I assume I need to write it in a different environment that is intended for that purpose. Any recommendations on something that is both simple and, ideally, free? Can the visual basic editor in the Excel or Word compile as an .exe?


    no, the built in VB(A) with Word and Excel cannot make an executable file, at least not as far as I know.
Reply

  • Finally, what is the easiest way to make a script like this into an executable? I assume I need to write it in a different environment that is intended for that purpose. Any recommendations on something that is both simple and, ideally, free? Can the visual basic editor in the Excel or Word compile as an .exe?


    no, the built in VB(A) with Word and Excel cannot make an executable file, at least not as far as I know.
Children
No Data