+ Reply to Thread
Results 1 to 1 of 1

Reference Sheet Name in File Path

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Excel 2010

    Reference Sheet Name in File Path

    Good afternoon,

    I am curious to know how you reference a particular sheet in a file path? I am assigning a filepath to a variable such as:

    strFile = "C:\Users\nworthen\documents\rrcc\Structured Personnel.xlsx"

    In this case, its data is being imported to Visio, but it could be anything...to Outlook, etc. By default, it pulls the data from the first sheet, but I'd like to be able to reference a particular sheet as an import. I tried selecting the entire sheet and defining a name then adding #givenName to the file path, but alas, no success.

    This is what I'm looking at:
    Please Login or Register  to view this content.
    This successfully creates my Visio org chart based on whatever I feed into the excel file. However, it would be terrific if I could specify what sheet to pull the data from.

    As long as I have headers that reflect the parameters I feed it (Name, Employee ID, Reports To..etc) it does the hard part. The only thing on the sheet is the headers and data and it correctly populates. The reason I'm going through this whole mess is I'd like to be able to break down the large org chart into a few smaller ones that would be reflected by what sheet it is pulled from. As is, if I wanted to create smaller charts, I would have to pull from different workbooks.

    Thank you for your time in this matter.

    Last edited by JBeaucaire; 08-29-2012 at 03:24 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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