hexagon logo

PC-Dmis to Excel, through PC-Dmis Script

I know there is currently a VB project that runs in Excel during execution that will pull information into the workbook during execution. I decided to venture out and try some of my own approaches with a combination of data I found online here and there.

What I have is a script that can be executed in program, without too much setup and hassle, that will export data into an excel workbook like a print command would. I feel this script offers a little more versatility.

I will not claim ownership of this program. I just tweaked it to fit my needs. So far I have it running, and it works quite well.

I will answer what questions I can, but for the most part I wanted to post it to have as a reference.

It's a long program........
Parents
  • example archive.zip

    Here is a zip file with a text document for the code, and an example excel file of the results.

    Apparently there is an error in the code, which is observed in the excel file.

    On one of the job tabs, if you scroll to the right you will see an insert of a blank line which throws the data off.
    i didn't catch this right away. I also don't know the culprit.

    Anyone have time to look into it? I will be puzzling through it.

    I fixed this problem.
    I removed the second section as an "Else" and just made it another if.
    Everything runs fine.

    I have also incorporated reporting out profile Min/Max values and include a bonus column for TP values.

    Attached Files
Reply
  • example archive.zip

    Here is a zip file with a text document for the code, and an example excel file of the results.

    Apparently there is an error in the code, which is observed in the excel file.

    On one of the job tabs, if you scroll to the right you will see an insert of a blank line which throws the data off.
    i didn't catch this right away. I also don't know the culprit.

    Anyone have time to look into it? I will be puzzling through it.

    I fixed this problem.
    I removed the second section as an "Else" and just made it another if.
    Everything runs fine.

    I have also incorporated reporting out profile Min/Max values and include a bonus column for TP values.

    Attached Files
Children
No Data