How do I determine the file path with the file name at the end

Posted to microsoft.public.excel.programming

Quietman

external usenet poster

Posts: 109

How do I determine the file path with the file name at the end

This gets me the file name but need the path seperate

Path = Left(ActiveWorkbook.FullName, Len(ActiveWorkbook.FullName) - _
InStrRev(ActiveWorkbook.FullName, Application.PathSeparator))
--
Helping Is always a good thing

Reply With Quote

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
Determine Excel file version with no file extension.	tjlumpkin	Excel Discussion (Misc queries)	2	July 23rd 09 06:59 AM
Formula too long - new file path is shorter than old file path - Excel 2003	Greg J	Excel Worksheet Functions	1	November 22nd 06 05:16 PM
Windows API to Determine if File is Local/Convert Path to Drive Letter	Johnny[_10_]	Excel Programming	0	March 10th 06 01:20 PM
Determine if XL file opened from Outlook or a saved file	quartz[_2_]	Excel Programming	1	September 16th 05 09:50 PM
How set file open path to filepath of file opened with Explorer ?	RandyDtg1	Excel Programming	0	May 14th 04 02:05 AM

All times are GMT +1. The time now is 06:25 PM.

Menu

About Us