Hyperlink

Altair Forum User

Hi,

  I need to take the file path of an exported H3D file and paste it in an excel. It should be like, The excel should display 'H3D' and when I click that, it should call that File path and open that H3D file. Can it be done? Any help is appreciated.

Altair Forum User

Hi BeslyD,

 

You can paste the path of the H3d file along with the file name as a HyperLink in Excel.

 

When you click on the HyperLink,  HyperView player will open with the animation file loaded.

Altair Forum User

Hi Prakash,

                 I did the same, but the problem is that the file path link is not getting converted as a hyperlink (So that I can directly open the H3D file Hyperview Player on one click of the link)

Altair Forum User

Have you tried this?

 

In MS Excel, Goto Insert>>HyperLink>>Existing File or webPage>>Select the H3d file and click OK.

Altair Forum User

Hi Prakash,

          I can do it by this way and get the macro of it. Its is

 

    ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _
        'C:\Users\besly_t\Documents\A1.h3d', TextToDisplay:= _
        'C:\Users\besly_t\Documents\A1.h3d'

 

so for using in tcl, I am modifying it as

 

 set A1 'C:/Users/besly_t/Documents/A1.h3d'
*writeh3dtofile $A1 1
 sheet Hyperlinks Add Anchor:=Selection
 Address:= $A1
 set dis [ TextToDisplay:= 'H3D' ]

$cells Merge
$cells Item 1 A $dis

 

But I am getting syntax errors in these..

 

Altair Forum User

Hi,

   I tried like this

 set A1 'C:/Users/besly_t/Documents/A1.h3d'
*writeh3dtofile $A1 1
set cells [$sheet range a22 n22]
$cells Merge
$cells Item 1 A $A1
$hyperlinks Add $anchor '' '$A1'

 

But I am getting syntax errors in these again.

Altair Forum User

Hi,

   I tried like this

 set A1 'C:/Users/besly_t/Documents/A1.h3d'
*writeh3dtofile $A1 1
set cells [$sheet range a22 n22]
$cells Merge
$cells Item 1 A $A1
$hyperlinks Add $anchor '' '$A1'

 

But I am getting syntax errors in these again.

Altair Forum User

Hi,

   I tried like this

 set A1 'C:/Users/besly_t/Documents/A1.h3d'
*writeh3dtofile $A1 1
set cells [$sheet range a22 n22]
$cells Merge
$cells Item 1 A $A1
$hyperlinks Add $anchor '' '$A1'

 

But I am getting syntax errors in these again.

Altair Forum User

Hi,

   I tried

             set A1 'C:/Users/besly_t/Documents/A1.h3d'
            *writeh3dtofile $A1 1
             set cells [$sheet range a22 n22]
             $cells Merge
             $cells Item 1 A $A1
             $hyperlinks Add $anchor '' '$A1'

 

But I am getting syntax errors in these also.

Altair Forum User

Hi,

   I tried

             set A1 'C:/Users/besly_t/Documents/A1.h3d'
            *writeh3dtofile $A1 1
             set cells [$sheet range a22 n22]
             $cells Merge
             $cells Item 1 A $A1
             $hyperlinks Add $anchor '' '$A1'

 

But I am getting syntax errors in these also.

Altair Forum User

Hi,

   I tried

             set A1 'C:/Users/besly_t/Documents/A1.h3d'
            *writeh3dtofile $A1 1
             set cells [$sheet range a22 n22]
             $cells Merge
             $cells Item 1 A $A1
             $hyperlinks Add $anchor '' '$A1'

 

But I am getting syntax errors in these also.

tinh

Hi what is $sheet ?

Try access excel via dde facility instead, or twapi also support

tinh

Hi what is $sheet ?

Try access excel via dde facility instead, or twapi also support

Altair Forum User

Hi,

  Sorry for the multiple replies... I wrote the code for Hyperlink. Thank You