[AccessD] Text format Access-->Excel

R. 
That's what we love about Microsoft. Things don't always work the same.
I have a cash worksheet with a custom tool bar I created with 22 macros
attached to it to do various things and my computer is the only one it
will work with. If my assistant opens the sheet and tries to use the
tool bar macro's it fails. Don't understand why.

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