If you right-click the Source excel parameter you'll have the option to turn that into a User Parameter, which means your colleagues are able to set that at runtime, no need to do any programming.

When it is a user parameter it can also be set through the command line or in FME Server.

I'm not sure i got that right.

I created a new User Parameter "SourceXLS" and linked (right click in the navigator on the two sources --> Link to User parameter) to it.

The two now are <not set> and show a red gear. If i try to deploy that as batch I get a window asking for Translation parameters.

Can you give me some more advices?

Sounds like you got it right. There's an easier way though: if you go in to the navigator and find the Source Excel parameter you can right click that and make it into a User Parameter (if it isn't one already, as this is default behaviour).

If you then run the workspace with the prompt and run option you'll be asked to review and if necessary change the user parameters. Same if you load it into the Quick Translator (so your coworkers don't even need to see the FME Workbench) or if you publish the workspace to FME Server.

I got the impression that that was what you wanted, but let me know if I understood you wrong.

Ok...so now if i run the workspace i got asked for the source, the destination AND for the value of my User parameter "SourceXLS". What am i supposed to enter in the "SourceXLS" field?

I think you can safely remove that one (the one you added) since it's already asking for the source file anyway.

Yep, but if i try to deploy that as a batch i still got asked to choose one of the two source i defined (even tho it's the same file)

Can you post a screenshot of your user parameters list? (the one in the Navigtator)

There it is

My questionis now...how can i automate the process, so that my coworkers only have to double click an icon navigate to select a different file and the workspace will do the translation?

When you open the workspace in the Quick Translator it will only show a window asking you for those user parmeters. The user can then set them at that point.

You can use the fmequicktranslator.exe that's in the FME installation directory: fmequicktranslator.exe workspace.fmw should do the trick. Set up a desktop shortcut for that and that's it.

If you don't want them to be able to set the destination file you can simply remove that parameter: right click on it and select "delete".

When you open the workspace in the Quick Translator it will only show a window asking you for those user parmeters. The user can then set them at that point.

You can use the fmequicktranslator.exe that's in the FME installation directory: fmequicktranslator.exe workspace.fmw should do the trick. Set up a desktop shortcut for that and that's it.

If you don't want them to be able to set the destination file you can simply remove that parameter: right click on it and select "delete".

I think that should actually do the trick...thank you very much for your help.