View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ajliaks[_5_] ajliaks[_5_] is offline
external usenet poster
 
Posts: 1
Default VBA question - getting name of workbook

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

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