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.
|