Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba code help
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba code help
Hi
use: xxx = Workbooks("book2.xls").Worksheets("sheet1").Range ("a1").Value -- Regards Frank Kabel Frankfurt, Germany coyote wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
Code to conditional format all black after date specified in code? | Excel Discussion (Misc queries) | |||
Drop Down/List w/Code and Definition, only code entered when selec | Excel Worksheet Functions | |||
option buttons run Click code when value is changed via VBA code | Excel Programming | |||
VBA code delete code but ask for password and unlock VBA protection | Excel Programming |