Name of the workbook when moving data back and forth

[claushojmark]

I am having some trouble writing a code for a macro that moves data between documents.

The document that I transfer data from is an excel extract from a survey, so everytime I have to run the macro, it is with a new document with a new name.

I can get so far as to move the first cell information into the other specified workbook, but I cannot get the macro to return to the the first document (the one where the name changes with every use).

Any suggestions?

 

[texasalynn]

you will want to assign the file name to a variable, for example

WName = ActiveWorkbook.Name