Or even:

Dim WkbkA as workbook
Dim WkbkB as workbook

set wkbkA = activeworkbook

set wkbkB = Workbooks.open(filename:="filepath/FileB.xls")

wkbkA.activate

===
But you don't usually need to select/activate stuff to work with it.

maybe just things like:

with wkbkA.worksheets("sheet1")
.range("a1").value = "Hi there!"
end with



Paulw2k wrote:

Hi Ahliaks,

Your last premise is wrong. FA holds the value "FileA.xls", FB holds the
value "FileB.xls.
Also avoid declaring variables as variant if possible. Here the file names
are just text so use String.

Dim FA as String
Dim FB as String

FA = ActiveWorkbook.Name
Workbooks.open "filepath/FileB.xls"
FB =ActiveWorkbook.Name

To get hold of "FileA.xls" again
Workbooks(FA).Activate
......

To return to "FileB.xls"
Workbooks(FB).Activate

Hope that helps

Paul

"ajliaks " wrote in message
...
hey!

I have this question:

I open workbook "File A" and save its name like

Dim FA as VAriant
FA = ActiveWorkbook.name

Now I open Workbook "File B" and save its name like:

Dim FB as Variant
FB = ActiveWorkbook.name

The problem is that FA now takes the same value of FB, and I need to
use the first value!

What can I do?

Thanks.


---
Message posted from http://www.ExcelForum.com/


--

Dave Peterson