Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default 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?








Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
SHARING Workbooks peyman Excel Discussion (Misc queries) 1 August 25th 09 05:05 PM
sharing workbooks peyman Excel Discussion (Misc queries) 4 August 10th 09 05:44 PM
Sharing Workbooks Tina Marie Excel Discussion (Misc queries) 0 March 17th 08 04:27 PM
Sharing workbooks Jo Davis Excel Discussion (Misc queries) 2 September 11th 06 03:54 PM
Sharing workbooks Eric[_14_] Excel Programming 1 December 4th 03 07:54 PM


All times are GMT +1. The time now is 08:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"