[AccessD] Text format Access-->Excel

Sue,
The macro's are stored in the workbook  on a network drive. I found out
that it was looking for an old copy of the spreadsheet instead of the
current one. Deleted the toolbar before I realized I would have to
rebuild it in her sheet. Excel stores the toolbars in an Excel11.xlb
file so since she didn't have any custom toolbars I copied mine to her
drive and it works fine now. What I probably would have had to do is
relink all 22 macro's to the buttons I had set up. And add the buttons I
had added since the old sheet because she didn't have all the buttons.
Thanks for the help anyway.

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 Klos, Susan
Sent: Thursday, April 22, 2010 2:38 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Text format Access-->Excel

Steve, where do you store your macros?  They can be stored in the
working workbook, a separate workbook or in the personal workbook.  If
stored in the personal workbook, others who want to use the macros on
their machines will have to have the macros copied into their personal
workbook or in a separate workbook they will need a copy of that
workbook on their computers and the file name and pathway has to be the
same.

 

Sue Klos

Senior Database Analyst

FLDOE

Susan.klos at fldoe.org

 

 

Date: Wed, 21 Apr 2010 15:55:30 -0500

From: "Steve Turner" <sturner at mseco.com>

Subject: Re: [AccessD] Text format Access-->Excel

To: "Access Developers discussion and problem solving"

      <accessd at databaseadvisors.com>

Message-ID:

      <B8E4CFB60139064980B1CAD7411A1509587F9C at PE2850-03.mseco.com>

Content-Type: text/plain;     charset="us-ascii"

 

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

 

 

Susan Klos

Senior Database Analyst

Florida Department of Education

Evaluation and Reporting Office

Phone: 850.245.0708

Fax: 850.245-0710

email: susan.klos at fldoe.org <mailto:susan.klos at fldoe.org> 

 

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