Showing results for 
Search instead for 
Do you mean 

Field Definition - Program Trigger

Avid Listener
Posts: 43
Country: United States

Field Definition - Program Trigger

[ Edited ]

In Act! 6.0 it was possible to set a trigger that would take you to a specific Excel Spreadsheet and then to a specific worksheet within the spreadsheet.


I was wondering if this is possible to do in Act! 11.0 Premium Ex.


I can get the spreadsheet to open formatting the field as url and file:// but not to a specific worksheet within the spreadsheet.


file://C:\a_dft\contactfiles\worksheetname.xls  -  this much works


According a googled article you can attach the following but it doesnot seem to work...


#Family!A1  or




Any thoughts to get to the specific worksheet greatly appreciated.


I am not looking to do this with an addon.






Message Edited by mmorgan_dft on 12-20-2008 11:55 AM
Message Edited by mmorgan_dft on 12-20-2008 11:56 AM
Copper Elite Contributor
Posts: 108
Country: United States

Re: Field Definition - Program Trigger



Someone can please correct me if i'm wrong but i'm pretty sure you can't pass parameters to the triggers like you used to be able to in the ACT! 6 days.  It probably has to be handled within the trigger itself either by calling a common dialog box or using a fixed filename.


Hope this helps.