Re: Cannot Utilize a Macro When Excel Is Opened By Another Program

Gord,
There are no projects/workbooks open after hitting Alt+F11 and then Alt+r
and then selecting Run Macro. There are no disabled item.

Jim
"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:klekq3pb8n8ddshl7hpofehi1s9mfv08bd@xxxxxxxxxx
Jim

Looks like MTS may be starting Excel in "safe mode" which would stop
Personal.xls from opening.

Hit Alt + F11 to open the Visual Basic Editor.

Alt + r to open the Project Explorer.

What projects/workbooks are open?

Is Personal.xls one of them?

Also, in the Excel window hit Help>About MS Excel>Disabled Items.

Personal.xls in there?


Gord

On Wed, 6 Feb 2008 16:35:02 -0500, "Jim Chesher" <jchesher1@xxxxxxxxx>
wrote:

It doesn't seem to make any difference if I have the Personal.xls open or
not when MST creates the workbook. I agree that the workbook that MST
opens
in not opening Personal.xls. When I open a blank workbook and I go to
macro
I can see the macro (called Ashland). In the dropdown box Macros In I can
select All Open Workbooks, This Workbook, Personal.xls or Book 1. When I
create the workbook from MST and go to macro I can not see the Ashland
macro plus the only options I see in the Macros In dropdown box are: All
Open Workbooks, This Workbook and Book 1. Personal.xls is not available.
I
am stumped .


"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:00tjq31mjp4324c5kqk2a01p462107atr8@xxxxxxxxxx
This macro is in your Personal.xls workbook which you know is open?

Perhaps due to the method that MST creates a new workbook and opens
Excel,
Personal.xls is not opening?

Which workbook is active when you try to run the macro?

Which work*** is active?

The macro as written will act upon the activeworkbook and active***.


Gord

On Tue, 5 Feb 2008 22:50:03 -0500, "Jim Chesher" <jchesher1@xxxxxxxxx>
wrote:

Gord, Thanks for the reply. I will try to answer your questions in
order
asked.
The other program is a business related software call Maintenance
Support
Tool (MST) that was privately developed.

The data from MST exports to *** #1 of a new workbook that just opens
on
my desktop.

As stated above it is actually *** #1 of a workbook.

I did not write the other program so I do not know how it opens up the
spread***.

Here is a cut and paste of the macro. All it really does is selects row
1
and applies Bold, Underline and Center. Then selects all and formats
all
columns for auto-fit.
Sub Ashland()
'
' Ashland Macro
' Macro recorded 1/20/2008 by James W. Chesher
'
' Keyboard Shortcut: Ctrl+a
'
Columns("G:G").Select
Selection.Delete Shift:=xlToLeft
Cells.Select
Selection.Columns.AutoFit
Rows("1:1").Select
Selection.Font.Bold = True
Selection.Font.Underline = xlUnderlineStyleSingle
With Selection
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlBottom
.WrapText = False
.Orientation = 0
.AddIndent = False
.IndentLevel = 0
.ShrinkToFit = False
.ReadingOrder = xlContext
.MergeCells = False
End With
End Sub

Jim Chesher

"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:50qhq350on1ts7lhiho23rnb6gk4caaepg@xxxxxxxxxx
What is the "other program" that manipulates various Access databases?

To where does the Excel spread*** of data get "exported" when you
press
one
key?

Is a spread*** a workbook or a work***?

You speak of both spreadsheets and workbooks so I can't tell which is
which.

How does the second program automatically open a
spread***(workbook?)?

Which macro can you not execute?


Gord Dibben MS Excel MVP

On Tue, 5 Feb 2008 17:41:03 -0500, "Jim Chesher" <jchesher1@xxxxxxxxx>
wrote:

Doesn't anyone have any idea or info on this issue?


"Jim Chesher" <jchesher1@xxxxxxxxx> wrote in message
news:4793e342$0$4976$4c368faf@xxxxxxxxxxxxxxxxx
I have created a macro in the Personal.xls workbook that is located
in
my
XLStart folder that works as I desire whenever I open a workbook. I
have
a
second program that manipulates various Access databases and will
automatically export an Excel spread*** of data by pressing one
key.
My
problem is that when this second program automatically open a
spread***
with the data in it I can not execute the macro for some reason. I
am
using Microsoft Office 2003. Any help is appreciated.









.

Loading