vba, get filename of this workbook

Posted to microsoft.public.excel.misc

external usenet poster

Posts: 7

vba, get filename of this workbook

I running a vba script inside a workbook. How do I get the complete
path to the workbook and name in which this script runs?

Thanks

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Workbook name in VBA doesn't match filename.xls	JoeAdidas21	Excel Discussion (Misc queries)	5	November 16th 07 03:37 PM
Saving XLS workbook with set filename	levertonfamily	Excel Discussion (Misc queries)	0	November 16th 06 05:52 PM
link to other workbook with changing filename	DN	Excel Worksheet Functions	6	August 30th 06 06:44 PM
Filename in footer automatically in new workbook.	cmorton89	Excel Discussion (Misc queries)	1	March 9th 06 12:52 PM
How do I remove multiple windows of 1 workbook (filename.xls:2,:3	Stacey D.	Excel Discussion (Misc queries)	2	March 1st 06 09:57 PM

All times are GMT +1. The time now is 07:55 PM.

About Us