AVEVA Community
AVEVA Community
  • Site
  • User
  • Site
  • Search
  • User
PDMS/E3D Forum
  • AVEVA World
PDMS/E3D Forum
Macros & Tools excel table to draft
  • Forums
  • Resources
  • Mentions
  • Sub-Groups
  • Tags
  • More
  • Cancel
  • New
  • Replies 37 replies
  • Subscribers 15 subscribers
  • Views 176 views
  • Users 0 members are here
Options
  • Share
  • More
  • Cancel
Related

excel table to draft

Tiberiu
Tiberiu over 12 years ago
 
  • Sign in to reply
  • Cancel

Top Replies

  • Tiberiu
    Tiberiu over 12 years ago +2
    Hi all, I've made a little macro for transferring the selected area from an excel sheet as a table in draft and I would like to share it with the community. I use it mainly for BOMs. It generates…
  • Viet Anh Le
    Viet Anh Le over 3 years ago in reply to timothy +1
    Hi, Can you please reupload the code? I can't find it in this post any more. Thank you!
  • francis dela cruz
    francis dela cruz over 12 years ago
    Hi, thanks for assisting, what do you mean by paste it as an excel macro?
    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
  • Tiberiu
    Tiberiu over 12 years ago
    Open excel, open a new macro (tools > macros - depends on the excel version), paste the code there and save it as a new macro, then when you select a range from the excel table itself and run the macro, it will generate a PDMS macro that you can run in the command window in PDMS Draft.
    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
  • Admin
    Admin over 12 years ago
    just one question.
    does your workflow looks like
    1. you create a drawing
    2. you create a report for drawlist items and output it to excel
    3. you get excel back to drawing area
    ?
    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
  • Tiberiu
    Tiberiu over 12 years ago
    [QUOTE=RUAV;77972]just one question.
    does your workflow looks like
    1. you create a drawing
    2. you create a report for drawlist items and output it to excel
    3. you get excel back to drawing area
    ?

    Your excel table range could be anything. The macro just makes it a PDMS macro that can be run in an existing draft drawing.
    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
  • me_hungry
    me_hungry over 12 years ago
    I think RUAR just wanna say, that if U have your data in PDMS its possible abtain table without excel import. With some code on pml..
    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
  • Tiberiu
    Tiberiu over 12 years ago
    You have all sorts of data in PDMS. Extracting them is subject of various macros. This one doesn't do that. :)
    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
  • me_hungry
    me_hungry over 12 years ago
    Well, the simple standart report may do it. :) Export data to excel*
    + add some automation with pml(few lines) and voila...
    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
  • Tiberiu
    Tiberiu over 12 years ago
    Feel free to do it :)
    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
  • francis dela cruz
    francis dela cruz over 12 years ago
    Hi I'm trying your instrucution and I hope I done right. I go to tool - macro - start new macro. then I paste it. Then save it as .xlsm?


    Open excel, open a new macro (tools > macros - depends on the excel version), paste the code there and save it as a new macro, then when you select a range from the excel table itself and run the macro, it will generate a PDMS macro that you can run in the command window in PDMS Draft.
    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
  • Tiberiu
    Tiberiu over 12 years ago
    You can find infos on excel macro customisation here.
    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • Cancel
<>