Excel VBA - link problem

  • Thread starter Thread starter gerok
  • Start date Start date
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
 
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)
 
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
 
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)
 
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... :
 
Back
Top