[AccessD] Text format Access-->Excel

Steve - there's a lot of things that could be happening:
1) macro security settings too high
2) worksheets are password protected
3) filters are on / lists are on
4) calculation mode is not set as expected
5) workbooks are hidden
And so on, and so forth...

It's not easy to program such a "freeform" environment.



> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> Steve Turner
> Sent: Wednesday, April 21, 2010 4:56 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [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
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>