| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Writing value to another file
I have this in code:
Range("OpenFile1.xls!A1").Value = "First Option" This writes "First Option" to Sheet1 of the file I think becuase that is the active sheet. "OpenFile1.xls" is open. How can I write "First Option" to "OpenFile1.xls" Sheet2 A1. I dont want to have to actually activate the window but just write to it. Thank you, Steven |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Writing to a .txt File | Excel Programming | |||
| writing to a DB4 file | Excel Programming | |||
| Writing a CSV file | Excel Programming | |||
| Writing a .txt file | Excel Programming | |||
| file writing | Excel Programming | |||
Threaded Mode
