Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Using Excel to WRITE to a closed Excel file
0 views
Skip to first unread message
Robert Crandal
Nov 24, 2009, 2:24:03 AM11/24/09
to
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.
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
Nov 24, 2009, 3:01:15 AM11/24/09
to
application.screenupdating=false
'do your thing
application.screenupdating=true
'do your thing
application.screenupdating=true
Tim
"Robert Crandal" <nob...@gmail.com> wrote in message
news:5TLOm.73365$Xf2....@newsfe12.iad...
RB Smissaert
Nov 24, 2009, 3:03:07 AM11/24/09
to
To write to to a closed workbook there are I think 2 ways, with ADO and with
BIFF.
Best to Google for both.
BIFF.
Best to Google for both.
RBS
"Robert Crandal" <nob...@gmail.com> wrote in message
news:5TLOm.73365$Xf2....@newsfe12.iad...
0 new messages