scripts

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • scripts

    Hi all,

    Never used scripts, need help. I downloaded a script from Wilcox - pcdmistoexcel:

    CS1 =SCRIPT/FILENAME= C:\EXCELSCRIPT.BAS
    FUNCTION/LoadExcel,,
    STARTSCRIPT/
    ENDSCRIPT/

    README:

    To install on a new computer:

    1) copy all files to c drive
    2) from the start, run , open line
    type regsvr32 c:\pcdmisutils.dll
    Note: there is a space between the 2 and the c in the line above
    3) set the security level in excel to medium( found under tool, macro, security)
    4) To automatically send results to excel, place this command at the end of your pcdmis program:

    CS1 =SCRIPT/FILENAME= C:\EXCELSCRIPT.BAS
    FUNCTION/LoadExcel,,
    STARTSCRIPT/
    ENDSCRIPT/

    5) Save the excel results file as a different name

    Did all of the above, wrote and ran a program, in the end, nothing happened. What did I miss? Please help, thanks in advance...
    sigpic3.7MR2

    "GREAT MINDS THINK FOR THEMSELVES"

  • #2
    pcdmisutils.dll keep that file in your C root dir. also the BAs and excel file should be kept same place ... Nothing at all comes up? what version of pcdmis?
    sigpic
    if you had soap on a rope it would be tied to yer ankle

    Comment


    • #3
      version 3.5, nothing at all comes up.
      sigpic3.7MR2

      "GREAT MINDS THINK FOR THEMSELVES"

      Comment


      • #4
        update: re-ran the program, at the end the Visual Basic popped open and I got this error:

        Compile error:
        Can't find project or library
        sigpic3.7MR2

        "GREAT MINDS THINK FOR THEMSELVES"

        Comment


        • #5
          Originally posted by rolsartom
          update: re-ran the program, at the end the Visual Basic popped open and I got this error:

          Compile error:
          Can't find project or library
          Had the same problem when I tried a while back, IT was no help. I gave up

          TK
          sigpicHave a homebrew

          Comment


          • #6
            Perhaps you need to add the PCDLRN.tlb for your version of PCDMIS to your Excel project.

            Craig
            <internet bumper sticker goes here>

            Comment


            • #7
              You have to open the excel file then go to tools tab and macro then visual basic editor select tools again and change what version of pcdmis is selected. you may have to unselect it and if you don't see 3.5 on the list exit and reopen the editor it will show up and select that
              sigpic
              if you had soap on a rope it would be tied to yer ankle

              Comment


              • #8
                Originally posted by T Miller
                You have to open the excel file then go to tools tab and macro then visual basic editor select tools again and change what version of pcdmis is selected. you may have to unselect it and if you don't see 3.5 on the list exit and reopen the editor it will show up and select that
                That is a much better way of explaining it than what I said. What Tom desribes is how you add the PCDLRN.tlb reference to your excel project. It is possible that the spreadsheet has a different version than the what you are using. Especially if you got it from someone else instead of creating it yourself.

                Craig
                <internet bumper sticker goes here>

                Comment


                • #9
                  Thanks Tom & Craig, I got it working. Next question, either of you guys know how to create scripts? Any suggestions as to how I may learn to do such?
                  sigpic3.7MR2

                  "GREAT MINDS THINK FOR THEMSELVES"

                  Comment


                  • #10
                    In the PCDBASIC help file (pcdbasic.chm), in the Automation chapter, there are some simple sample script files that should provide you with what you need to get started.
                    Jared Hess - Techwriter @ WAI
                    [View Reporting Tutorials Here]

                    Comment


                    • #11
                      First you need a problem that can not be (or that you perceive that can not be) solved by conventional means, or a current process you would like to streamline. Then you see what scripting can be done to solve it. I know this is not a great answer but for myself I have a hard time making up problems that a script will solve. When I encounter a problem I decide if VB/A is the right way to go then I start looking things up to see if it can be done.

                      If you really must get involved without a problem existing and you don't know much about it get a book (I like this one, but it is not really a "tutorial" book). Also record some macros in Excel and anylize them and get to know what each line is doing. It is kind of tough to give advise on how to start scripting. Partly because I am a noob and partly because you just plain need justification. Once you can justify it it is like writting a story something clicks and before you know it you are rolling right along.

                      Keep posting here and checking this forum and it will start to come together if the need for scripting exists. My first rule is you must have a need.

                      Craig

                      As an edit: What Jared said, also get the PCDBASIC manual for your version.
                      Last edited by craiger_ny; 10-20-2006, 11:46 AM.
                      <internet bumper sticker goes here>

                      Comment


                      • #12
                        Hey Jared,

                        Where do I find pcdbasic.chm? Is that in the manual (printable)?
                        sigpic3.7MR2

                        "GREAT MINDS THINK FOR THEMSELVES"

                        Comment


                        • #13
                          It is the help file, it is in your PCDMIS directory (.chm is the help file extension)

                          Craig
                          <internet bumper sticker goes here>

                          Comment


                          • #14
                            Craig,

                            I am glad you made mention of the need. I don't necessarily know if scripting will solve this one. But maybe you can provide some insight...

                            ...How do I convert .rtf files into excel? Meaning, reports saved to file for a 5pc dimensional - match build. (knuckleheads from GM want reports on a spreadsheet) I have tried the regular cut and paste, but then nothing is lining up. I cannot re-run the program, parts are already installed on the vehicle. And typing is out of the question. Ideas???
                            sigpic3.7MR2

                            "GREAT MINDS THINK FOR THEMSELVES"

                            Comment


                            • #15
                              Originally posted by rolsartom
                              Craig,

                              I am glad you made mention of the need. I don't necessarily know if scripting will solve this one. But maybe you can provide some insight...

                              ...How do I convert .rtf files into excel? Meaning, reports saved to file for a 5pc dimensional - match build. (knuckleheads from GM want reports on a spreadsheet) I have tried the regular cut and paste, but then nothing is lining up. I cannot re-run the program, parts are already installed on the vehicle. And typing is out of the question. Ideas???
                              Do you have Datapage and did you save the data to Datapage? Make a measurement report, save it to a file, then open it with Excel, you should be able to get everything to line up nice and neat that way.
                              sigpic
                              Originally posted by AndersI
                              I've got one from September 2006 (bug ticket) which has finally been fixed in 2013.

                              Comment

                              Related Topics

                              Collapse

                              Working...
                              X