View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bill Lunney Bill Lunney is offline
external usenet poster
 
Posts: 68
Default reurning currently opened file name

application.ActiveWorkbook.Name

--

Regards,


Bill Lunney
www.billlunney.com

"Rosson Cain" wrote in message
...
does anybody know of a way to retrieve the name of the
file that is currently open (excel 97) in VB without going
through browser menus and such? any help would be
appreciated.