[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."