Skip to main content
B
BernardWielfaer1-Visitor
1-Visitor
January 25, 2012
Question

Download files from Windchill by Excel

  • January 25, 2012
  • 12 replies
  • 15340 views

Dear Reader,


Our purchase department is spending hours downloading manuallya dxf file for each drawing beforesending it to the manufacturer.


We like to automate this manual downloadfrom Windchill and would like to work with Excel (and VBA).


The number of the drawing to look for could be entered in the Excel list and the vba code could download the dxf file attached to the drawing and place this in a folder.


Does anyone have experience with this and likes to share his code ?


Best regards,


Bernard Wielfaert

12 replies

Show previous replies
D
dwilliams1-Visitor
1-Visitor
January 31, 2012
Hi All,

Please see the attached presentation and example files for creating a
Windchill Report Interface in Excel. It's fairly straight forward but
please feel free to contact me if you have any questions.



Thanks,

Dax


    D
    dwilliams1-Visitor
    1-Visitor
    January 31, 2012

    Attached is the export (.qml file) for the report used in the example.
    This may be helpful for those of you who haven't created a report using
    Report Manager. You can import this .qml file into your development
    environment.

    Hope this helps,

    Dax

      M
      mdebower18-Opal
      18-Opal
      March 11, 2016

      Dax Williams‌

      Do you know a way to automate logging into Windchill from Excel?   I have created a report and added it to Excel and would like to avoid having to log into the Windchill server when I refresh the report. 

      If there is a way to log into the server with no manual interaction, that would be great.  I need to automate some reports for sharing with others, and need to get it to the point where once the Excel file is opened, it refreshes the web query automatically.

      -marc

      D
      dwilliams1-Visitor
      1-Visitor
      March 11, 2016

      Hi Marc DeBower‌,

        I haven't attempted to bypass the login in Excel but I've heard it can be done. I believe Jered Larsen‌ figured out a way around the login. Maybe reach out to him and see if he still has this information?

        Just to note, once you open excel and login, you shouldn't need to login again if you refresh of the query. At lease not with the ones we've created. If you do get the information, please post it back to the report page so we don't have to figure it out ourselves.

      Good Luck,

      Dax

      Terms & ConditionsAccessibility statement