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!

application.screenupdating=false
'do your thing
application.screenupdating=true

Tim

"Robert Crandal" wrote in message
...
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!

To write to to a closed workbook there are I think 2 ways, with ADO and with
BIFF.
Best to Google for both.

RBS


"Robert Crandal" wrote in message
...
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!