Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default reurning currently opened file name

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.
  #2   Report Post  
Posted to microsoft.public.excel.programming
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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
file links incorrect when file is re-opened s-steege Excel Worksheet Functions 2 November 8th 08 11:26 PM
Looking up A name in a table and reurning all rows that are associ David A. Excel Discussion (Misc queries) 3 June 15th 07 10:37 PM
cannot open the excel file, the file is already opened cannot open the excel document Excel Discussion (Misc queries) 1 May 19th 06 07:45 AM
Copying the Editing in one file to Another opened XLS file Ahmad Excel Worksheet Functions 1 May 27th 05 02:04 PM
Opened File Tim Zych[_2_] Excel Programming 0 July 11th 03 04:27 AM


All times are GMT +1. The time now is 10:34 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"