[AccessD] Text format Access-->Excel

Rocky Smolin rockysmolin at bchacc.com
Wed Apr 21 17:23:53 CDT 2010


Asger:

The cells ended up as General format.  But I worked around it with a
different method.

Rocky
 

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

Rocky,
For me this statement in an Excel procedure:
	Rows("5:5").NumberFormat = "@"
- will format all cells in row 5 to text.
Can you please elaborate what's not working for you? 
Asger

-----Oprindelig meddelelse-----
Fra: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] På vegne af Rocky Smolin
Sendt: 21. april 2010 22:22
Til: 'Access Developers discussion and problem solving'
Emne: Re: [AccessD] Text format Access-->Excel

Steve:

That was my first try - I cribbed it from a macro I recorded.  But it didn't
seem to work.

R 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve Turner
Sent: Wednesday, April 21, 2010 12:01 PM
To: Access Developers discussion and problem solving
Subject: Re: [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/> 

 

 


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


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list