Using Excel to WRITE to a closed Excel file

[Robert Crandal]

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!

 

[Tim Williams]

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

Tim

 

[RB Smissaert]

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

RBS