I did it with an Excel sheet and DDE interaction. Prerequisites: - An Excel template, which need to be open at the time of "import" to the Windows User Tool. - a defined Page Name in Excel to refer to. Let´s choose "Page-1" - hopefully ONE operating system language for ALL clients, where Excel is installed, otherwise you get crazy for column and row translations for each OS language in your active links. Use a set fields action with a value like this: (For each field, one set fields action is necessary.)
for German: $DDE$ excel;Page-1;c:\programme\microsoft office\office\excel.exe;Z112S4 for English: $DDE$ excel;Page-1;c:\program files\microsoft office\office\excel.exe;R112C4 for Spanish: $DDE$ excel;Page-1;c:\Archivos de programa\microsoft office\office\excel.exe;F107C5 enjoy ;-) Martin Sturm Remedy Fairly Skilled Professional (RFSP) akRemedy wrote: > Can someone please help with the following; > > How can I access Windows Explorer from Windows ARS User Client to > 1. select an XLS file > 2. open it > 3. change format of three columns to show numeric data to 3 decimal places. > 4. copy data from several columns in each row to an ARS 5.1.2 regular form > and commit the record to Remedy. > > Many thanks in anticipation of your support. > -- > View this message in context: > http://www.nabble.com/Want-to-Load-Data-from-.XLS-tf2298988.html#a6387987 > Sent from the ARS (Action Request System) mailing list archive at Nabble.com. > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
