On 2002-10-08 20:21, Duncgee wrote:
I have a number of workbooks from which a macro copies data. This data is then pasted into another workbook. How can I have the macro paste the filenames as well as the data.
formula in a blank cell in the source workbook before copying to the destination, then copy that as a value to the destination workbook. That will give the complete filename, including path and sheet name. If you only want the filename, replace with