VBA question - getting name of workbook

[ajliaks]

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 t
use the first value!

What can I do?

Thanks

 

[kkknie]

What exactly are you trying to do and where are you trying to do it?
That is, where is the code running from and how is it run?

I'm on a slow connection with a couple of screaming kids, so excuse i
I cannot post back that quickly.

 

[Vasant Nanavati]

From the Immediate Window:

FA = ActiveWorkbook.name
Debug.Print FA
Book1

'Open new workbook
FB = ActiveWorkbook.name
Debug.Print FB
Book2
Debug.Print FA
Book1

I don't see the problem.

 

[Paulw2k]

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

 

[Dave Peterson]

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