Excel VBA - link problem

G

gerok

I have to worksheets, each with a lot of macros. The two sheets don'
work so well together, so it necessary to run them in separate Exce
applications - then it does not crash all the time.

But sheet A gets data continuously from sheet B (sheet B is link to a
external database). When A and B is running in separate Exce
applications the automatic linking of data between them does not work.

Can this be fixed without macros?

If not, how can i, in a marcro run from A, select application B, save
and update links in A?

Thanx in advance for any help
 
B

Bob Phillips

Gregor,

Surely the solution is to find out why they work so well together, and fix
that.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
G

gerok

Bob said:
Surely the solution is to find out why they work so well >together
Click to expand...
and fix that.

That is not an option, one of the macros are written by an externa
consultant, and the code is password protectet. When I run the tw
sheets i same Excel appl., Excel just crashes without any erro
message. So troubleshooting becomes almost impossible
 
B

Bob Phillips

Passwords are easy to crack!

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
G

gerok

Bob said:
Passwords are easy to crack!
Click to expand...


That might be, but I don't think that will solve my problem. This shee
has rather complicated macros, designed for exchanging data from
database. So I rather not mess with that... :
 
Top