[AccessD] Text format Access-->Excel

Rocky
Try
Range(??).Select
Selection.NumberFormat = "@"

Steve A. Turner
Controller
Mid-South Engineering Co. Inc
E-Mail: sturner at mseco.com and saturner at mseco.com


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Wednesday, April 21, 2010 1:22 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Text format Access-->Excel

Dear List:

 

I'm trying to format a row in an excel spreadsheet as text but can't
seem to
get the syntax right.  It starts out .Rows("5:5").NumberFormat but don't
know what to set it equal to.  I tried "@" with no luck.

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/>