Name of the workbook when moving data back and forth

claushojmark

New Member
Joined
Jul 9, 2012
Messages
3
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?
 

Some videos you may like

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

texasalynn

Well-known Member
Joined
May 19, 2002
Messages
8,458
you will want to assign the file name to a variable, for example

WName = ActiveWorkbook.Name
 

Watch MrExcel Video

Forum statistics

Threads
1,108,674
Messages
5,524,204
Members
409,565
Latest member
Suilenroc

This Week's Hot Topics

Top