[AccessD] Text format Access-->Excel

Mark, 
Thanks for the reply. It started me working on the problem. I hadn't
much time in the past to look at it. The toolbar that came up with the
sheet on her computer was looking for an old spreadsheet. I deleted the
toolbar before I realized that I couldn't copy it back in. I wound up
copying my Excel11.xlb file and replaced her's and now the toolbar
works. She didn't have any custom toolbars in her file so it didn't
replace anything she didn't already have.

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 Mark Simms
Sent: Wednesday, April 21, 2010 4:56 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [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
>



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