Jim DeMarco
Jdemarco at hshhp.org
Mon Nov 24 10:12:12 CST 2003
Dale, A really neat and easy way to find out how certain Excel objects behave is to simply record a macro that does what you need. Then go into the VBA editor and see what properties were set and how. HTH, Jim DeMarco Director Product Development Hudson Health Plan Tarrytown, NY -----Original Message----- From: Dale Kalsow [mailto:dkalsow at yahoo.com] Sent: Monday, November 24, 2003 10:29 AM 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 *********************************************************************************** "This electronic message is intended to be for the use only of the named recipient, and may contain information from Hudson Health Plan (HHP) that is confidential or privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this message is strictly prohibited. If you have received this message in error or are not the named recipient, please notify us immediately, either by contacting the sender at the electronic mail address noted above or calling HHP at (914) 631-1611. If you are not the intended recipient, please do not forward this email to anyone, and delete and destroy all copies of this message. Thank You". ***********************************************************************************