I've tested this quickly and this is the setup I've used. Hope this is similar to what you are trying.
As you can see inside the Export activity the file name provided is myfile.csv
This will result in the file being exported to export folder inside the installed location.
When configuring the attachment inside delivery, type has been selected as "The filename is computed during delivery analysis (it cannot depend on recipient profile)" and then path has been provided as "export/myfile.csv"
This will send the exported file to designated email address.
When specifying the Export (V4 compatibility) activity what options would need to be defined in order to successfully pass this data through to a Delivery. Also is it possible to define the attachment type (xls etc)?
Finally when defining the attachment in the delivery activity what are the steps needed to do this. The calculated options all seem to require a local file location.
Apologies for the many questions. I've been banging my head on this for a while and now have a complete mental block on it...