Hello, I would like to be able to open a .sldprt file by sw via excell. Thank you

3D Design Volume Model
1

Via an excell sheet with sw part file names, I would like to click on the name of the part under excell to open this part under SW.

Thank you

2

Hello

Right-click in the cell where the reference is located and create a hyperlink, then go find the path of the sldprt file.

Thomas

1 Like
3

Here is an illustration


excel.bmp
1 Like
4
Hello

Depending on the type of data in Excel, the formula will be:

 
  • If it's for a list of filenames that all exist in the same directory:
    =LIEN_HYPERTEXTE("C:\My Documents\"&A1)
    Where "C:\My Documents\" is the path
    And where A1 contains the file name.
 
  • If it's for a file list that includes the path:
    =LIEN_HYPERTEXTE(A1)
    Where A1 contains the file name
 
  • If they are file names in different folders, no solution.

 

1 Like
5

@Tomalan the Hypertext links seems to me to be the best solution.

 

Kind regards

 

Bastien

1 Like
6

Good evening

From experience, we are limited by the number of characters, so avoid subfolders of subfolders and long document names

excel create the link but after said error can't find the file

 

I think the limit is still 256 characters 

 

1 Like