+ Reply to Thread
Results 1 to 3 of 3

Calling another workbook not working

  1. #1
    Forum Contributor
    Join Date
    06-10-2005
    Location
    Central Jersey
    Posts
    117

    Angry Calling another workbook not working

    I don't get it, I just tested this out with a dummie workbook and it worked fine. Now, I'm trying to use it on the workbook I'm working on, and it's not working at all.

    The Name of the workbook I'm trying to call another workbook from is called "Freezer Project" and in the "Bio-Analytical" worksheet I'm trying to call the workbook "Bio-Analytical" to call the worksheet "Bio-Analytical" cell A4 while I'm in cell A4 in the "Freezer Project" workbook......When I try to call this using this formula:

    =[Bio-Analytical.xls]Bio-Analytical!A4

    it won't work!?!?!?

    Is this because the names are the same????

    Any info will be greatly appreciated.
    Thanks
    Joe

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,829
    When a sheet/book name contains certain characters (such as that hyphen), the book/sheet name needs to be enclosed in single quotes. ='[bio-analytical.xls]bio-analytical'!a4

  3. #3
    Forum Contributor
    Join Date
    06-10-2005
    Location
    Central Jersey
    Posts
    117
    Thanks MrShorty, I read about that before, and I kept trying to mess with the single quotation marks but I couldn't get it to work.....I think I've been staring at a computer screen for way too long.

    But thanks it works great now.

+ Reply to Thread

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