Results 1 to 2 of 2

Thread: Reference Range("").value in another workbook [Resolved]

  1. Jul 1st, 2008, 12:16 PM #1
    Spajeoly
    Spajeoly is offline

    Thread Starter
    Frenzied Member Spajeoly's Avatar
    Join Date
    Mar 2003
    Location
    Utah
    Posts
    1,068

    Reference Range("").value in another workbook [Resolved]

    Alright, I have done this a billion times before but for some reason I cannot figure out what is going wrong.

    I am not able to grab the value from a cell using the workbook name, sheet name and cell address like below:

    Code:
    MsgBox Workbooks("book1").Sheets("Sheet1").Range("$A$1").Value
    Can someone please point out my moronic mistake?
    Last edited by Spajeoly; Jul 7th, 2008 at 12:21 PM.
    Reply With Quote Reply With Quote
  2. Jul 1st, 2008, 12:27 PM #2
    Spajeoly
    Spajeoly is offline

    Thread Starter
    Frenzied Member Spajeoly's Avatar
    Join Date
    Mar 2003
    Location
    Utah
    Posts
    1,068

    Re: Reference Range("").value in another workbook

    Code:
    MsgBox Workbooks("book1.xls").Sheets("Sheet1").Range("$A$1").Value
    God, what an idiot.

    Yeah, .xls

    Ever had one of those days?
    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