how to set external cell value?

C

chipsy

Joined
Feb 20, 2007
Messages
5
Reaction score
0
hi
does anybody know how to set cell value in closed external workbook, from say cell value of active worksheet ?
the following doesn't work
Code: 
Application.Workbooks("F:\DESKTOP\za abc\xy_z.xls") _ 
 .Worksheets("Sheet1").Range("H1").Value = 123
/error 1004 - application defined or object defined error/
thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
Run-time Error '1004' 1
Run-time error 1004 8
Get value in a cell 2
how to assign contents of a cell to a macro variable 3
Find a value in a sheet and replace it with another value if it matches 8
How to set focus on an ActiveX ListBox 7
Run-time error '1004' 1

Top