Skip to main content
8-Gravel
June 14, 2014
Solved

Excel Hyperlink to open part in Creo-view Express

  • June 14, 2014
  • 13 replies
  • 7470 views

Hi all,

I am having a problem with excel hyperlink. In excel i am adding hyperlink to open .prt file in creo view express, but the error comes is something like this "no program is registered" it comes when i clink on the hyperlink. so please help me out. what might be the problem. is it in excel settings or in my system settings?


This thread is inactive and closed by the PTC Community Management Team. If you would like to provide a reply and re-open this thread, please notify the moderator and reference the thread. You may also use "Start a topic" button to ask a new question. Please be sure to include what version of the PTC product you are using so another community member knowledgeable about your version may be able to assist.
Best answer by mtrivedi

yes.

same problem i'm facing....

13 replies

2-Explorer
June 24, 2014

Normally this should be a matter of what is registered in Windows. When you double-click on a *.prt file in Explorer, it launches Creo View Express?

mtrivedi1-VisitorAnswer
1-Visitor
June 29, 2014

yes.

same problem i'm facing....

13-Aquamarine
June 29, 2014

Hi Jignesh,

It sounds like you just lost your file type association. This is easy to fix. Try the steps below (or use the slide which attempts to provide some screen grabs to help you).

  1. Select Windows Start
  2. Select Default Programs
  3. Select Associate a File Type or Protocol With a Program
  4. File the file type you wish to associate (.prt in this case). Select Change Program.
  5. Browse to your installation of Creo View. Select launch_pview.exe as the default application for your file type. Select OK.
  6. When you double-click a .prt file (or open a link to a .prt file), Creo View should now launch.

See the slide below for screen grabs (click the picture for a larger image).

filetypeassoc.png

I hope this helps!

Thanks...

-Brian

2-Explorer
July 3, 2014

Hi Jignesh, have you tried Brian's technique? Did it solve the issue? I believe that normally the file types should be registered when installing Creo View Express, but maybe the program has been copied to the computer instead? Gunter

1-Visitor
July 9, 2014

Hi Gunter,

i've tried above suggested by martin but nothing happens..

Plz help if you have any idea....

24-Ruby III
July 9, 2014

Hello to all,

I spent a short time testing the problem...

1.]

I installed Creo View Express using "C:\PTC\Creo2_M070\Creo 2.0\Common Files\M070\install\addon\pvx32_64\pvexpress\CreoView_Express_32_64.msi" package.

2.]

I created "D:\tmp\creo\prt0001.prt".

3.]

I clicked WindowKey+R and typed "D:\tmp\creo\prt0001.prt" >>> Creo View Express launched and displayed the part. Nice.

4.]

I opened Excel sheet and created the hyperlink pointing to "D:\tmp\creo\prt0001.prt" >>> I received the error message "No application is assigned for this file type". Strange. It looks like "C:\Program Files\PTC\Creo 2.0\View Express\bin\pvexpress.exe" cannot be launched through hyperlink.

5.]

I decided to use Macro (I created it in old xls Excel file).

I put "D:\tmp\creo\prt0001.prt" into A1 cell (ordinary text).

I created the Macro - see blue lines (source=WWW).

Sub Makro1()
'
' Makro1 Makro
'

Dim Program As String
Dim TaskID As Long
Program = "C:\Program Files\PTC\Creo 2.0\View Express\bin\pvexpress.exe" + " " + ActiveCell.Value
TaskID = Shell(Program, vbNormalFocus)

End Sub

I selected A1 cell and run the macro. Creo View Express launched and displayed the part. Problem resolved .

Martin Hanak

1-Visitor
July 9, 2014

Hi Martin,

Nice solution but can't we open with using hyperlink as i have so many parts.i have to assign macro to each and every part....

24-Ruby III
July 9, 2014

Manthan,

can you upload an example or a picture. I am not able to imagine, how your Excel book looks like.

I think that you can press some key combination to open part, whose name is located in a cell.

Martin Hanak

1-Visitor
July 10, 2014

Hi Martin,

find below screen shot as you can see i have code and it's description

plz suggest how can i open the part with HYPERLINK...hyperlink.JPG