[AccessD] Excel Automation Question

Erwin

Try something like this:

With Worksheets("Sheet1").Columns("A")
    .ColumnWidth = .ColumnWidth * 2
End With----- Original Message ----- 
  From: Erwin Craps 
  To: Access Developers discussion and problem solving 
  Sent: Tuesday, November 25, 2003 1:52 AM
  Subject: RE: [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
  _______________________________________________
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com