[AccessD] Excel Automation Question

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




More information about the AccessD mailing list