How do I store the name of a currently active file [one of several]
before activating another file containing macros and some data stored in
its cells, so that I can return to the first file for entering more
data?


*** Sent via Developersdex http://www.developersdex.com ***

This seems a simple matter. Maybe I'm not understanding your
situation.
Dim FirstBook as string
FirstBook=activeworkbook.name
'your stuff here
workbooks(FirstBook).activate

James

On Jun 7, 10:39?am, Gordon Humphreys
wrote:
How do I store the name of a currently active file [one of several]
before activating another file containing macros and some data stored in
its cells, so that I can return to the first file for entering more
data?

*** Sent via Developersdexhttp://www.developersdex.com***