scripts

[rolsartom]

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...

[T Miller]

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?

[rolsartom]

version 3.5, nothing at all comes up.

[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

[tking]

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

[craiger_ny]

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

Craig

[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

[craiger_ny]

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

[rolsartom]

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?

[JaredHess]

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.

[craiger_ny]

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.

[rolsartom]

Hey Jared,

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

[craiger_ny]

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

Craig

[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???

[Matthew D. Hoedeman]

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.