[AccessD] Text format Access-->Excel

Haven't followed this thread but I just saw this spreadsheet in a Steve Bass
column.  He said: "Brent Wheeler suggested I try a nifty Excel spreadsheet
from Sanketham. (Don't bother with the site's preview -- it never loads.)
The spreadsheet is loaded with 150 smart and esoteric formulas ready for you
to use, such as removing nonprintable characters from imported data,
converting weights and temperatures, and tons more."

http://www.box.net/shared/v0btlnm18n

There might be something in there that will help.

Kathryn

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