Thread: vba code help
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_4_] Don Guillett[_4_] is offline
external usenet poster
  
Posts: 2,337
Default vba code help
try book2.xls

--
Don Guillett
SalesAid Software

"coyote" wrote in message
...
Good morning,
What did I do wrong??

I have 2 files open in excel (1 instance). Book1 and
Book2. Running the following macro in Book1 results in an
error on the xxx line (Object doesn.t support this
property or method):

Sub test()

Dim xxx As String

xxx = Windows("book2").Worksheets("sheet1").Range
("a1").Value

End Sub





Reply With QuoteReply With Quote