Rocky Smolin
rockysmolin at bchacc.com
Sun Apr 11 22:14:31 CDT 2010
Thanks.
R
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Collins, Darryl
Sent: Sunday, April 11, 2010 5:12 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Excel Automation Question
Sheet activation is not required or desirable even.
Just "xlSheetBOMs.Cells.Delete" will do fine.
Excel does not need the sheet to be active, or even visible for this to
work.
Cheers
Darryl
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Monday, 12 April 2010 2:38 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Excel Automation Question
Too easy.
xlSheetBOMs.Activate
xlSheetBOMs.Cells.Delete
Seems to work.
R
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Sunday, April 11, 2010 9:19 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Excel Automation Question
P.S. - This is VBA from Access in case that wasn't clear.
R
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Sunday, April 11, 2010 9:12 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Excel Automation Question
Dear List:
Having trouble getting the right syntax for this - I want to select all the
cells in a worksheet and clear those cells.
Anyone know the right commands for this?
MTIA
Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com <http://www.e-z-mrp.com/>
www.bchacc.com <http://www.bchacc.com/>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
"This e-mail and any attachments to it (the "Communication") is, unless
otherwise stated, confidential, may contain copyright material and is for
the use only of the intended recipient. If you receive the Communication in
error, please notify the sender immediately by return e-mail, delete the
Communication and the return e-mail, and do not read, copy, retransmit or
otherwise deal with it. Any views expressed in the Communication are those
of the individual sender only, unless expressly stated to be those of
Australia and New Zealand Banking Group Limited ABN 11 005 357 522, or any
of its related entities including ANZ National Bank Limited (together
"ANZ"). ANZ does not accept liability in connection with the integrity of or
errors in the Communication, computer virus, data corruption, interference
or delay arising from or in respect of the Communication."
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com