Running Macro from One Dynamic Workbook to Another

Hi All,

At the moment I am trying to transfer some data from one dynamic workbook to another. A part of this is to see if a value is in a cell on one of the workbooks (openWb) and then run a macro that is in the other book (currentWb). because neither of them have a fixed file name, I think it isn't has straight forward as usual. I have tried a whole bunch of ways round it, but non have worked. any assistance or ideas will be welcomed greatly.

Code:

Please Login or Register  to view this content.

Thanks

Dale

Hi Xladept,

Unfortunately it had an object required error. However looking into it, online suggests taking a look at a file called the dao3032.dll in the registry. But, this file is missing. Wondering whether this is the reasons for the issues, I have my company's IT dept on the case, and I'll get back to you on what happens when the file is re-installed.

But some rep for the help non-the-less

Rgds

Dale

Hi xladept,

Thank you greatly for your assistance. your revised version of called the other subs was far more efficient. It turned out that I had to activate the workbook with the subs in otherwise I would get a script out of range error. As far as the object required issue is concerned, I managed to get around it.

Have another rep point.

Thanks

Dale

oops, it appears I cant give you another point yet.