Rocky Smolin
rockysmolin at bchacc.com
Sun Apr 11 11:37:30 CDT 2010
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