Excel Script help

  • Filter
  • Time
  • Show
Clear All
new posts

  • Excel Script help

    Hi all - new user to the forums here. I have a couple of questions for you all. Are there any of you that use the Excel script from the Pc-Dmis website? I am currently using it (very successfully), but it seems to be lacking a few things that would be very nice to have.

    What I am looking for specifically is a complete list of all the data variable names that are available for use in the excel vb script itself (Maybe called the command array?).

    I've managed to modify the script to include a few extras, like changing the data sent to excel into .csv files (part by part), a couple of descriptor search and replace routines, and also bonus tolerance for true positions. But, I would also like to be able to add simple comment lines into the output - perhaps by using the commet/oper command.... I just simply have no idea how to pull that information out of the data array sent to Excel.

    If anyone has any ideas, I'd love to discuss them!

    Thanks all!

  • #2
    Export your file that you have comments in as a .bas file. Then go to the file you exported and open with notepad or wordpad whichever you like and you will see the commands that PC-DMIS uses in basic script for each of your features, dimensions, comments, etc.

    You should be able to use that information along with whatever is in the script already to make the mods you need.

    I hope I understood your question correctly and didn't give you some info you didn't need.


    • #3
      That looks like exactly what I'm after! Thank you SOO much!


      Related Topics