Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Somebody told me that the best way to use Excel (and VBA)
to write to a closed (.xlsx) Excel file is to first open the file, write changes using VBA code, then close the file. Well, I don't really want the target write file to open on the screen and let my users see the file changes happen. My question is, is there a way to invisibly or stealthily open a closed Excel file, write changes, then close the file without anybody see this all happen?? Also, does anyone know of an alternative way to write to a closed Excel file using VBA/Excel?? Thank you! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Write to a closed excel spreadsheet | Excel Programming | |||
write cell values to a closed file | Excel Programming | |||
Write data in a closed file? | Excel Programming | |||
Write data in a closed file? | Excel Programming | |||
Write to Array from other closed Excel file | Excel Programming |