View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sungibungi Sungibungi is offline
external usenet poster
 
Posts: 15
Default Activating Workbooks

I have opened up a file using the following code:

Dim fName As String
fName = Application.GetOpenFilename()
Workbooks.Open Filename:=fName

Then I switch to a different workbook to, tranferring data. When done, I
need to go back to this "fName" worksheet.

The logical code (at least to me...) Worksheets(fName).activate obviously
doesn't seem to be working. How do I make this happen?

Thanks so much in advance.