Results 1 to 4 of 4

Thread: Excel Filename

  1. Jul 20th, 2004, 02:46 PM #1
    Esham
    Esham is offline

    Thread Starter
    Addicted Member
    Join Date
    Feb 2004
    Posts
    155

    Excel Filename

    Is there a way to get a cell to show the current filename?
    Reply With Quote Reply With Quote
  2. Jul 20th, 2004, 07:09 PM #2
    MartinLiss
    MartinLiss is offline
    Former Admin/Moderator MartinLiss's Avatar
    Join Date
    Sep 1999
    Location
    San Jose, CA
    Posts
    33,431
    I'm no Excel expert but I was fooling around and came up with this.

    =CELL("filename",A1)

    (The file has to have been saved)
    Tips, Examples & Tutorials:
    A valuable forum tool • Generate unique TreeView keys • TreeView with "open" and "closed folder" icons • Time code using GetTickCount • How to trap the Tab key • Scroll a form • NumberBox ActiveX control • Color a ListView row • An InputBox form • How to use SaveSetting and GetSetting • A program registration scheme • Spellcheck a Textbox • Resize controls • Open Windows Explorer at Last Visited Path • A Blackjack Game • Count lines of code • Private Message Viewer • Copy/Paste VB Code • Paste VB Code Add-In • Insert Procedure Names Add-In • A calculator for the game of Spider • My review of REALbasic 2008 • VB6 Debug Tutorial • Picture/Video Viewer • VBF Photo Contest Winners


    2009 - 2016
    Reply With Quote Reply With Quote
  3. Jul 21st, 2004, 07:07 AM #3
    Esham
    Esham is offline

    Thread Starter
    Addicted Member
    Join Date
    Feb 2004
    Posts
    155
    Originally posted by MartinLiss
    I'm no Excel expert but I was fooling around and came up with this.

    =CELL("filename",A1)

    (The file has to have been saved)
    I was hoping to get just the filename. Not the complete path including the worksheet name.
    Reply With Quote Reply With Quote
  4. Jul 21st, 2004, 07:09 AM #4
    Esham
    Esham is offline

    Thread Starter
    Addicted Member
    Join Date
    Feb 2004
    Posts
    155

    POSSIBLE RESOLUTION

    Originally posted by MartinLiss
    I'm no Excel expert but I was fooling around and came up with this.

    =CELL("filename",A1)

    (The file has to have been saved)
    This is what I came up with so far.

    =LEFT(MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,255),FIND(".",MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,255))+3)
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width