Sharing Workbooks With Macros
 

I'm new to using queries and recording macros but am into it up to my
eyeballs at present. MY project involves automating a workbook that updates
economic indicators from various websites. The objective is to share the
results when finished with my investment club members.

When I sent the partially finished workbook to two members, neither were
able to run the macros. The queries could be executed but not the macros.
Apparently something is stored on my computer that should have been stored
with the workbook.

Can someone shed some light on this for me please?

Sharing Workbooks With Macros
 

Kind of vague, John<g.

You might ask them to go to the VBE (Alt-F11) with your workbook open, and
check under Tools, References for anything marked "missing".

--
Jim Rech
Excel MVP
"John Gregory" wrote in message
...
| I'm new to using queries and recording macros but am into it up to my
| eyeballs at present. MY project involves automating a workbook that
updates
| economic indicators from various websites. The objective is to share the
| results when finished with my investment club members.
|
| When I sent the partially finished workbook to two members, neither were
| able to run the macros. The queries could be executed but not the macros.
| Apparently something is stored on my computer that should have been stored
| with the workbook.
|
| Can someone shed some light on this for me please?
|
|

Sharing Workbooks With Macros
 

What error message do they get.

With only your workbook open,
They should go to the VBE and look in Tools=Reference and see if anything
is marked as MISSING.

If so, then if that item isn't used in your project, you should remove it as
a reference from your copy of the workbook and save the workbook. Then try
sending them the corrected version.

--
Regards,
Tom Ogilvy

"John Gregory" wrote in message
...
I'm new to using queries and recording macros but am into it up to my
eyeballs at present. MY project involves automating a workbook that
updates
economic indicators from various websites. The objective is to share the
results when finished with my investment club members.

When I sent the partially finished workbook to two members, neither were
able to run the macros. The queries could be executed but not the macros.
Apparently something is stored on my computer that should have been stored
with the workbook.

Can someone shed some light on this for me please?

Sharing Workbooks With Macros
 

I'll ask the other parties for more detail and be back shortly. Thanks for
the tip so far.


"Jim Rech" wrote in message
...
Kind of vague, John<g.

You might ask them to go to the VBE (Alt-F11) with your workbook open, and
check under Tools, References for anything marked "missing".

--
Jim Rech
Excel MVP
"John Gregory" wrote in message
...
| I'm new to using queries and recording macros but am into it up to my
| eyeballs at present. MY project involves automating a workbook that
updates
| economic indicators from various websites. The objective is to share the
| results when finished with my investment club members.
|
| When I sent the partially finished workbook to two members, neither were
| able to run the macros. The queries could be executed but not the
macros.
| Apparently something is stored on my computer that should have been
stored
| with the workbook.
|
| Can someone shed some light on this for me please?
|
|

Sharing Workbooks With Macros
 

Well, Tom and Jim... I'm still waiting for something specific I can pass on
to you two from the two people who can't seem to open my workbook and make
the macros run. One guy tells me it's not the workbook nor the macros...
it's the operating system; XP. He says it prevents these workbooks from
executing the macros to protect itself. ???? Doesn't sound right to me,
but....

Is it?

"Tom Ogilvy" wrote in message
...
What error message do they get.

With only your workbook open,
They should go to the VBE and look in Tools=Reference and see if anything
is marked as MISSING.

If so, then if that item isn't used in your project, you should remove it
as
a reference from your copy of the workbook and save the workbook. Then
try
sending them the corrected version.

--
Regards,
Tom Ogilvy

"John Gregory" wrote in message
...
I'm new to using queries and recording macros but am into it up to my
eyeballs at present. MY project involves automating a workbook that
updates
economic indicators from various websites. The objective is to share the
results when finished with my investment club members.

When I sent the partially finished workbook to two members, neither were
able to run the macros. The queries could be executed but not the
macros.
Apparently something is stored on my computer that should have been
stored
with the workbook.

Can someone shed some light on this for me please?

Sharing Workbooks With Macros
 

OK! Just got the screen print:

The part that's highlighted says:
With ActiveSheet.QueryTables.Add(Connection:=_
"FINDER;C:\Documents and Settings\John\Application
Data\Microsoft\Queries\MZM.iqy"_, Destination:=Range ("A1"))

This is what the receiving party gets when attempting to examine the macro
using Alt F11. It looks to me like the macro is trying to find the macro I
wrote on MY machine rather than hers. I thought the macro was supposed to be
tied to the workbook so it would travel with it when shared with someone.

She can't get my macros to work yet the execute perfectly on my machine.



"John Gregory" wrote in message
...
Well, Tom and Jim... I'm still waiting for something specific I can pass
on
to you two from the two people who can't seem to open my workbook and make
the macros run. One guy tells me it's not the workbook nor the macros...
it's the operating system; XP. He says it prevents these workbooks from
executing the macros to protect itself. ???? Doesn't sound right to me,
but....

Is it?

"Tom Ogilvy" wrote in message
...
What error message do they get.

With only your workbook open,
They should go to the VBE and look in Tools=Reference and see if
anything
is marked as MISSING.

If so, then if that item isn't used in your project, you should remove
it
as
a reference from your copy of the workbook and save the workbook. Then
try
sending them the corrected version.

--
Regards,
Tom Ogilvy

"John Gregory" wrote in message
...
I'm new to using queries and recording macros but am into it up to my
eyeballs at present. MY project involves automating a workbook that
updates
economic indicators from various websites. The objective is to share
the
results when finished with my investment club members.

When I sent the partially finished workbook to two members, neither
were
able to run the macros. The queries could be executed but not the
macros.
Apparently something is stored on my computer that should have been
stored
with the workbook.

Can someone shed some light on this for me please?