MS Excel / VBA help thread

You are reading a single comment by @Dramatic_Hammer and its replies. Click here to read the full conversation.

•

rhb

Copying sheets from one workbook to another, the macro and action button still point to the old workbook. Is there a simple fix?

Edit: new workbook developer > Macros shows no macros. Presume these don't copy across?

Edit 2: the pivot tables reference the old workbook too (i can fix this tho)

•

Dramatic_Hammer in reply to @rhb

No that I've found, my workaround is to use a hidden config sheet with file paths/etc. There's probably a better way!

If you're just copying sheets, then no I don't think macros copy as well - you either need to save the whole workbook as a copy or copy individual macros across. Obvs make sure it's .xlsm to keep the macros!

•

rhb in reply to @Dramatic_Hammer

I was approaching it wrong... in the end all I had to do was make a copy of the macros & pivots workbook and copy the other worksheets (no macros or pivots) across into that.

Will be trickier if ever there's macros in both workbooks, i found a tip to export & import these in this case.

About

Avatar for Dramatic_Hammer @Dramatic_Hammer started