Merging 2 files with macros

[hansbQR]

Dear all, I have a problem which I cannot solve (up till now)
I have two files (A and B). Both files have macro's which are activated by clicking knobs in some sheets in file A and file B.

When I merge these two files, I copy all sheets of file A into file B.
Next I import all modules of file A into file B (exporting / importing)

The result is, that the combined file (which was file B), all knobs of former file A still rever to the old file A.
Up till now I repair this problem by re-addressing the macro's of file A to the combination file.

I am looking for a autotated solution to save time and avoid failures (introduced by the hand job).

Is there anybody who can help me out?

Rgds hansbRQ

 

[jmacleary]

Hi there. You could try putting the relevant macros in individual worksheet code areas of flie A, then when the sheet is copied the macros will go with it and refer to the newly created copy.

 

[hansbQR]

Hi there. You could try putting the relevant macros in individual worksheet code areas of flie A, then when the sheet is copied the macros will go with it and refer to the newly created copy.

This is brilliant, many thanks. The most simple solution & it really works fine.
Rgds, hansQR

 

[jmacleary]

Youre welcome.