Henry
Here's a small def file to show how it should work - you should be able to
copy the active link to your form and change the fields it's using. Remove
the .txt from the end of the file name.
Regards
David Sanders
Remedy Solution Architect
Enterprise Service Suite @ Work
==========================
ARS List Award Winner 2005
Best 3rd party Remedy Application
See the
<http://www.westoverconsulting.co.uk/downloads/ESS_Concepts_Guide.pdf> ESS
Concepts Guide
tel +44 1494 468980
mobile +44 7710 377761
email [EMAIL PROTECTED]
web http://www.westoverconsulting.co.uk
<http://www.westoverconsulting.co.uk/>
_____
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Douglas, Henry
Sent: Thursday, July 26, 2007 4:48 PM
To: [email protected]
Subject: Re: Open Excel doc from a Command Line process
Thanks David but I'm not having success with constructing that syntax still
trying thou. i.e. no space between the reg location and path statement and I
tried surrounding with double ticks
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\App
Paths\Excel.exe \\path\name.xls <file:///\\path\name.xls> .
Thanks
Henry Douglas x2065
IT Support Center
Remedy Software Administrator
First Command Financial Group
__20060125_______________________This posting was submitted with HTML in
it___ __20060125_______________________This posting was submitted with HTML
in it___ __20060125_______________________This posting was submitted with
HTML in it___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
char-set: windows-1252
#
# File exported Thu Jul 26 17:20:19 2007
#
begin schema
name : testGetExcel
core-version : 2
upgrade-version: 0
num-fields : 3
timestamp : 1185466736
owner : Demo
last-changed : Demo
default-vui : Default Admin View
num-vuis : 1
export-version : 9
schema-type : 4
next-field-id : 536870912
permission : 73402\2
permission : 73401\2
permission : 0\2
vui {
id : 536870912
name : Default Admin View
label : Default Admin View
timestamp : 1185466361
vui-locale :
vui-type : 1
owner : Demo
last-changed : Demo
display-prop : 9\20\4\18\Default Admin
View\264\6\0\60019\4\21\ViewWebAlias536870912\165\2\0\164\2\0\203\40\0\214\6\1\201\2\93150\202\2\45600\
}
field {
id : 700500064
name : zzTemp2
datatype : 4
fieldtype : 1
create-mode : 1
option : 4
timestamp : 1185466361
owner : Demo
last-changed : Demo
maxlength : 255
menu-style : 1
qbe-match-op : 2
fulltext-optns : 0
permission : 0\1
permission : 3\2
permission : 4\2
permission : 73201\2
permission : 73402\2
display-instance :
536870912\18\20\4\7\zzTemp2\3\41\2\9675\7200\62550\9300\4\6\0\5\6\2\60\40\1\61\40\72\27\8\16\28\6\4\29\6\1\7\40\2147483648\143\40\47\170\40\0\21\41\2\0\400\8&
display-instance :
100\2100\151\41\2\8212\0\49949\2100\65\41\2\8550\0\8550\0\66\41\2\50512\0\52874\2100\228\40\1\231\6\0\
}
field {
id : 700032010
name : PathExcel
datatype : 4
fieldtype : 1
create-mode : 1
option : 4
timestamp : 1185466736
owner : Demo
last-changed : Demo
maxlength : 128
menu-style : 1
qbe-match-op : 2
fulltext-optns : 0
permission : 0\1
permission : 3\2
permission : 4\2
permission : 73201\2
permission : 73402\2
display-instance :
536870912\18\3\41\2\9675\4200\62550\6300\4\6\1\5\6\2\7\40\2147483649\20\4\10\Path
Excel\27\8\16\28\6\4\29\6\1\60\40\1\61\40\72\143\40\26\21\41\2\0\400\8100\2&
display-instance :
100\151\41\2\8212\0\49949\2100\65\41\2\0\0\0\0\66\41\2\50512\0\52874\2100\228\40\0\170\40\0\231\6\0\
}
field {
id : 536870910
name : btnGet Path
datatype : 32
fieldtype : 0
create-mode : 2
option : 4
timestamp : 1185466724
owner : Demo
last-changed : Demo
permission : 0\1
permission : 3\2
permission : 4\2
permission : 73401\2
permission : 73402\2
display-instance :
536870912\12\7\40\2147483650\2\8\1\3\41\2\64575\4400\72900\6300\4\6\1\5\6\2\110\4\8\Get
Path\143\40\4294967295\170\40\0\21\41\2\0\0\0\0\151\41\2\0\0\8325\0\6&
display-instance : 5\41\2\0\0\0\0\66\41\2\0\0\0\0\
}
end
char-set: windows-1252
#
# File exported Thu Jul 26 17:20:27 2007
#
begin active link
name : testGetXL-GetPath
timestamp : 1185466748
export-version : 9
owner : David Sanders
last-changed : Demo
actlink-order : 5
wk-conn-type : 1
schema-name : testGetExcel
actlink-mask : 1
actlink-control: 536870910
enable : 1
permission : 0
action {
set-field :
0\700500064\101\4\85\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\App
Paths\Excel.exe\Path\
}
action {
auto-server : Windows Script Host Shell Object
auto-visible: 0
auto-clsId : {F935DC22-1CF0-11D0-ADB9-00C04FD58A0B}
auto-action : $PathOffice$ = RegRead( $zzTemp2$ )
auto-COM :
1\7\RegRead\38\{24BE5A30-EDFE-11D2-B933-00104B365C9F}\3084\38\{00020400-0000-0000-C000-000000000046}\0\1\700032010\1\4\Name\8\\0\1\700500064\
}
object-prop :
6\60006\4\0\\60008\40\0\60009\4\0\\60010\4\0\\60016\4\1\0\60017\4\1\0\
end
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
