[AccessD] Excel Automation Question

Something like this.



objExcelWorkSheet.Columns(x).ColumnWidth  

objExcelWorkSheet is a reference to the worksheet, but I supose you can
use activeworksheet or something to...

Erwin

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dale Kalsow
Sent: Monday, November 24, 2003 4:29 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Excel Automation Question


Goood Morning Everyone,

 

I have an excel automation question.  I have Access XP and though vba I
am writing to an excel spread sheet.  Does any know how to set the
column width of a column in excel and then format that column for time.

 

Thanks in advance.

 

Dale



---------------------------------
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com