Hello all, any help would be much appreciated as I'm in over my head.
I've got a user who is generating a list of items. The list can be placed in and Excel form (.csv or .xls) or a .txt file. I need to be able to have the User hit a button on our (custom) form and have the information in the file copied to a Character field on the open Remedy form.
One suggestion I've had is to have an active link run a batch process (?!) to retrieve the information from the file and copy it to the form but I have no idea how to handle this.
Thanks in advance.

Remedy 4.5.1
MS SQL Server 7

Have you tried using a $DDE$ feature to grab the information from the Excel sheet? Or could you import the Excel information into a Dead Form (a form that is only used to hold the Excel Spreadsheet information only for workflow purposes), then have a Set Field action pull the data from there? Either option will work in you situation.