how do i display the "path" and filename?

hi,

whats the function where it shows the location of the file?

th

--
Message posted from http://www.ExcelForum.com

0
1/30/2004 10:10:28 PM
excel 39879 articles. 2 followers. Follow

5 Replies
439 Views

Similar Articles

[PageSpeed] 10

Hi
try the following:
File path and file name:
=CELL("filename",A1)

File path only
=LEFT(CELL("filename",A1),FIND("[",CELL("filename",A1),1)-1)

File name only
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1),1)+1,FIND("]",CEL
L("filename",A1),1)-FIND("[",CELL("filename",A1),1)-1)

HTH
Frank

> hi,
>
> whats the function where it shows the location of the file?
>
> thx


0
frank.kabel (11126)
1/30/2004 10:24:52 PM
You could add the file as a hyperlink.  You'd also be able to open th
file directly from excel

--
Message posted from http://www.ExcelForum.com

0
1/31/2004 6:25:52 AM
Is this what you are looking for?

=Cell("Filename")

this will only work if the file has been saved

--
Message posted from http://www.ExcelForum.com

0
1/31/2004 10:53:54 AM
Hi dcronje!

See Frank's reply.

You *must* use a reference:

=CELL("Filename",A1)

If you don't give a reference to a cell, Excel will calculate when
another sheet is active and the formula returns the name of the active
sheet, not the sheet actually containing the formula.


-- 
Regards
Norman Harker MVP (Excel)
Sydney, Australia
njharker@optusnet.com.au
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.


0
njharker (1646)
1/31/2004 11:03:44 AM
That's a good summary but it wasn't mentioned in this thread.
David Hager tried to explain it to me and I ignored it for quite
awhile until I was shown an actual demonstration.  I elaborated
a bit on it to make it even more clear but one can see it at the
top of     http://www.mvps.org/dmcritchie/excel/pathname.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel    [site changed  Nov. 2001]
My Excel Pages:  http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:        http://www.mvps.org/dmcritchie/excel/search.htm

"Norman Harker" <njharker@optusnet.com.au> wrote in message news:401b8b90$0$28871
> See Frank's reply.
>
> You *must* use a reference:
>      =CELL("Filename",A1)
>
> If you don't give a reference to a cell, Excel will calculate when
> another sheet is active and the formula returns the name of the active
> sheet, not the sheet actually containing the formula.



0
dmcritchie (2586)
2/1/2004 10:38:29 AM
Reply:

Similar Artilces:

Specified path does not exist
When i tried to open a asf or wmv attachment file in MS Outlook 2002 it gives the following error: "c:\documents & setting\yoongkt\local settings\temporary internet files\content.IE5\dn33p14a\file.asf" The specified path does not exist. Check the path and then try again. Appreciate it if you advise on the problem and provide a solution. Many thanks. KT ...

How to get "cookies" folder path in win32,not in MFC
Hi I want to get the path to "cookies" folder programmatically.Actually I am creating an application which is not using MFC,using win32.In every machine the path to the cookies folder is different,but prgrammatically I need to get the path to cookies folder in each machine.Is there any way to do that?can u plz provide me any sample code? > I want to get the path to "cookies" folder programmatically. SHGetSpecialFolderPath CSIDL_COOKIES Dave On Aug 3, 1:26 pm, David Lowndes <Dav...@example.invalid> wrote: > > I want to get the path to "cookies&...

Stencil path and Page Size problem with Automation in VC++ 6.0
I am using Visio 2000, with our software to provide automation (using VC++ 6.0) I am facing two problem currently: 1. i want to use my own stencils to be used in drawing for that, i am using function GetStencilPaths() of IVApplication object to retrive current stencil path. this function return CString object, now i am conctenating my stencil path to the same string and using SetStencilPaths() function with this value. this is causing problem in object destruction (CString) and displays a voilation occured message. 2. My second proble is that, my application works fine on those m/c on wh...

Filename field path display with mapped drive
How do I get MS Word to display the complete path when I use the filename field. When I check the box to include the path, it displays the mapped drive letter and abbreviated path, not the complete path. For example, MS Word 2007 now displays the path as y:\mfg\tooling guide.doc instead of the full path \\svr05\Documents\mfg\tooling guide.doc I did not have this problem in Office 2003. I'm now running Office 2007 and Windows 7 Quote from June 2009: -------------------- The registry setting described in http://support.microsoft.com/kb/322955 still seems to function in ...

Return-Path
Hi All, My setup: Exchange Server 2003 XP Clients with Outlook 2003 My users are sending from a 'company e-mail' by using the 'send on behalf of' feature of that particular object (which so happens to be a user). Unfortunately, receipts from a 3rd party mail provider are being sent to the originator of the message (using the Return-Path: message header item) rather than the From: (in the message header) field. So my problem is that these receipts are only being seen by one user rather than the whole group. How can I setup the various messages that are sent as the company e...

path to Public folders
This is a multi-part message in MIME format. ------=_NextPart_000_0008_01C4AF86.FAE6BA80 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi folks, We have a standalone W2k3 DC with Exchange 2k3. It seems like the path = in the IIS manager is not correct and we cannot write to the location. = In the IIS manager the location for 'Public' under the default web site = is: \\.BackOfficeStorage\dc.ourdomain.com\Public Folders For the 'ExchWeb' it is: C:\Progran Files\Exchsrvr\ExchWeb What is the path to the actual folder for the...

How to set up search path in MFC?
Under my application folder, there is folder called Driver which has xxx.dll in it. c:\application\Driver My application run in application folder. How to setup the search path in my application so that it can find the xxx.dll in Driver folder? > Under my application folder, there is folder called Driver which has > xxx.dll in it. > > c:\application\Driver > > My application run in application folder. > > How to setup the search path in my application so that it can find the > xxx.dll in Driver folder? I dont follow this. Does your application depend upon this ...

show the document path in the office menu bar
Please add an option to show the full pathname to the current file in the menu bar without having to write vb code, add the limited column 'Document Location' command, etc. Just, please let me show the full pathname in the menu bar (Office 2007). Thanks. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader a...

Change Exchange Drive Letters (Cluster & Data Path)
I am wondering on the correct procedure for changing the drives for Exchange 2003 in a clustered environment. The Exchange 2003 Clustered resource was created with a 'data path' = m:\exchsrvr This resulted in all of the databases, SMTP, MTA, Search folders being created within this folder. I can change the database directories using ESM, SMTP directories using ESM x.400 (MTA) directory using ESM I can change the MTA Run Directory by editing the registry when the server is active and manually changing the path I have not been able to change the Search directory (either by ed...

Retrieving data from another workbook (path?)
Happy Saturday! Please can anyone help. I've done the searches and can't find an clues...I think maybe my question is just too simple.... I am getting a macro to password protect a worksheet with a password i a specif cell in another open workbook. The code: ActiveSheet.Protect Password:=Sheets("sheet1").Range("a1").Value ....works perfectly for inputting the password from within the sam workbook, but I'm blowed if I can find the code for referencing specific cell in a different open workbook. Logic tells me it should be ActiveSheet.Protec Password:...

variable path
Hi all, I've got a series of numbers in the first column 0001 0002 0003 0004 I'd like to take the values of that column and reach the path...\\...\[value].xls.. is it possible.. I'd like to do this so I can shift the formula in the whole sheet. Thanks Rossella ps sorry if this is not clear but english is not my mother tongue ...

Long File Path
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel Hello, <br><br>When I try to save my Excel worksheet files somewhere on the HD, Excel comes back with an error message saying &quot;The file path you entered is too long&quot;. I do not want Excel to tell where to save my files! Anybody can help? <br><br>Thanks! <br> Ali Excel is most likely telling you nothing of the sort -- OS X is. Make sure you have Office & OS X fully updated then run Disk Utility - Repair Disk Permissions. If you continue to have a problem you...

how do you change a save in path in publisher.
In order to change a default font, I am told to create a nor.pub file and save as, but to change the save in path. don't know how to do that. can any body explain so a dummy can understand? -- Dennis in layout Dennis <olddodge@charter.net> was very recently heard to utter: > In order to change a default font, I am told to create a nor.pub file > and save as, but to change the save in path. don't know how to do > that. can any body explain so a dummy can understand? You're actually instructed to create a normal.pub file rather than a nor.pub file. To change the...

Money 2006 CDN, upgrade path?
Originally had a Money 2004 OEM version, not sure if it was canadian, then bought Money 2006 CDN (i.e. "standard"). It kills me to be missing the "debt planning" and "cash flow forecasting". Should have researched before buying, but too late for that. Does an upgrade (specifically upgrade pricing) exist to bring me to deluxe?, or do I have to pay full price. :-( No, only the Standard version of 2006 works in Canada. Also, Microsoft doesn't have an upgrade path between versions short of returning any product under Microsoft's money back guarantee...

Insert attachment file path as text into message.
I'm using Outlook 2002. When I get a message with an attachment, I :- 1 - file the attachment into an appropiate directory on my hard disk relating to the content. 2 - remove the attachment from the message 3 - copy the file path using Directory Opus (a replacement Windows Explorer) 4 - Paste the file path into the message body 5 - save the message into an appropiate outlook directory So I can always retrieve attachements that arrived with messages when I need to. I've looked at various add-ins but they all seem to automatically save the attachments in pre defined directories, whic...

Names of workbooks
One thing that drives me crazy is that I want to work on files at home, but when I bring them from the office to home and work on them, when I get back to the office, the full path names of the sheets I've worked on are saved. For example, if I have a workbook Houston.xls, and I refer to cells in the another file called Scorecard.xls, all references are to the full paths, and I have to spend time deleting all the full pathnames that were valid at home to the full path at work (on a server naturally, so the path names are really long. This is in Excel '97 (ancient I know, but the co...

IWebBrowser2:How to set HTML page content from a Stream contains <img> with src set to relative path rather than full image path
Hello, I try to use IWebBrowser2 to load html content from a stream, which contains image with "src" set to relative file path rather than full file path, it seems IWebBrowser2 can not resolve the image path even I put the executable and the image file under the same directory. The dynamic html content is simple as "<html><head><title>test</title></head><body><img src='test.jpg'></body></html>". Could you tell me how to do that? I use IHTMLDocument2::write to load html content dynamically. Thanks a lot. ...

Hotmail Server Path
Hi All, I need the paths as I need to enter them into my Evolution email app. Sorry for posting it here, but, Microsoft is a absolute mess for finding specific things. Cheers. coolboarderguy. does evolution support http? if so, do you have a paid account? http://www.slipstick.com/addins/services/online.htm#hotmail -- Diane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in 24 Hours Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide) Author, Google and Other Search Engines (Visual QuickStart Guide) Outlook Tips: http://www.outlook-tips.net/ Outlook & Exchange S...

All users path
Hi! I have a weird path problem. Model path (Application.TemplatesPath): Gives a path in my windows user "documents and settings" folder Startup path (Application.StartupPath): Gives a path in my windows user "documents and settings" folder Add-in path (Application.LibraryPath): Gives a path in an Office directory The Model and Startup paths are "user"-defined and the add-in path are "all users" defined. I would like to have all "all users" path including Model and Startup. What's the way? Thanks, Thierry Paradis. >>I have...

Linked Table Path
How do you set or change the path for a linked table. The Server will always be called backoffice and the other terminals will be named Term1, Term2 etc. I will be doing installs of my database on difeerent systems and I need to be able to change the linking. Thanks DS "DS" <bootybox@optonline.net> wrote in message news:C6TEi.6$tN3.5@newsfe12.lga... > How do you set or change the path for a linked table. > > The Server will always be called backoffice and the other terminals will > be named Term1, Term2 etc. I will be doing installs of my database on > ...

Outlook 2010: Cannot find this file. Verify the path and file name
I am test Window 7 and Outlook 2010 on two different PCs. On one of them I cannot access any .pst files. When I try I get this message; Cannot find this file. Verify the path and file name are correct. I have attempted to find a fix for this, or at least with is causing the error, no luck so far. Any suggestions Do you have read/write access to these pst-files? Copy them to your Desktop for testing purposes and try to connect to them via; File-> Open-> Open Outlook Data File -- Robert Sparnaaij [MVP-Outlook] Coauthor, Configuring Microsoft Outlook 2003 http://w...

Update Path for 2004 11.2.3 -> 11.5.7 ?
I have Office 2004 version 11.2.3 installed on an older Tiger latptop, and want to know if anyone knows what the simplest update path is to the current 11.5.7. Hopefully I don't have to download every single point update in between. Doesn't microsoft have combo updaters? Thanks. Hi Gerald, simply use Microsoft AutoUpdate to have your Mac download all the updates for you. You can activate this application by clicking on the Update command in the Help menu of every single Office application. If you want to download the updates manually, just go to the Mactopia ...

CRM 3.0 SBS Install fails with 'Path not found' error
Running SBS2003 with SP1 and SQL2000 with SP4. Install gets a long way through the installation process, but fails with "Action Microsoft.Crm.Setup.Server.ImportDefaultDataAction failed. - The system cannot find the path specified" The log doesn't indicate what the offending path is. I am loading the sw from the CD (D:). The Environemt Diagnostics Wizard when run reports no error. It installs the CRM services & programs, it creates the SQL databases. The IIS manager does not have the CRM website visible. Where do I go from here. I have tried the install a couple of ...

Alternative routing path
Dear all, We have an Ex2K3 Server. Other than make use of the its SMTP virtual server, can I configure it to use extra SMTP server as an alternative route for failover? I have tried to configure two SMTP connector with different cost: Connector 1.) Address Space *, Cost 1, send via DNS resolving Connector 2.) Address Space *, Cost 10, send via smarthost The result is no matter how the cost is and all emails only send via the smarthost. The reason why I ask this question is that some destination hosts are inaccessible by broken connection, and the smarthost could bypass the disconnect...

How to change default path of CFileDialog?
I want to open data file in "C:\temp" (e.g.), but CFileDialog always direct to 'C:\My Document' at opening. My code: CFileDialog dlg(TRUE); dlg.m_pOFN->lpstrInitialDir = "C:\temp"; kathy wrote: > I want to open data file in "C:\temp" (e.g.), but CFileDialog always > direct to 'C:\My Document' > at opening. > > My code: > > CFileDialog dlg(TRUE); > dlg.m_pOFN->lpstrInitialDir = "C:\temp"; > kathy: CFileDialog dlg(TRUE); dlg.m_pOFN->lpstrInitialDir = "C:\\temp"; You must escape the \ ...