Double-clicking the file will run the batch file immediately. For more complex copy operations, Windows has another copy command called robocopy.

Is it possible to read from a txt file to get a value to use in a batch file. I'm able to do it if I know what value I'm looking for in the txt file, but I'm not able to read line by line ...

The default location is the same workbook. If you click on the down-pointing arrow, the screen at right will appear, giving you the option of moving (or copying, if you checked the Create a copy box) ...

Microsoft's latest function makes it easier to copy and move files using drag and drop in the breadcrumb navigation. We'll show you how to use it.