vVal = Activeworkbooks.Worksheets("Sheet9").Range("B10"). Value

--
Regards,
Tom Ogilvy

"Oli Oshiz" wrote in message
...
I am trying to 9a macro that allows me to open up another excel
file and then specify which tab on the opened work book I want to pull
information from.

Does anyone know how to do this?

Thanks in advance for your help.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!