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?
|