Results 1 to 4 of 4

How to use a cells value in a filename (VBA)

Threaded View

  1. #1
    Registered User
    Join Date
    07-04-2011
    Location
    Portland, Oregon
    MS-Off Ver
    Excel 2003
    Posts
    7

    Post How to use a cells value in a filename (VBA)

    I was wondering if it is possible to use a value that the user inputs into a cell, in a filename for linking to another spreadsheet in VBA.

    For example, if the user enters "C-11838" in cell B4, I want to be able to set the forumla in C4 to ='K:\GMG\Nets on Floor\Finished Nets\[C-11838.xlsm]Net Summary'!$B$4

    I can't figure out how to set it up so that the number before .xlsm can be a variable.

    Any help would be greatly appreciated!
    Last edited by Greg_2; 07-14-2011 at 09:03 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1