1.

Solve : Excel 2010 Workbook Copy?

Answer»

Hi,

I am copying a current workbook to another NAME using a macro, and I want the macro named Workbook_Open to be copied to the new file, but I cannot get it to work.
Can anyone help?

Thanks,I think some clarification or more precise wording might help in understanding your question.
Quote

I am copying a current workbook to another name using a macro
You want to copy a current workbook to another, i.e. new, workbook, right?

Quote
I want the macro named Workbook_Open to be copied to the new file
You want the macro copied to the new file. Is that right? If so, then apparently you created the macro in a WAY that only left it in the workbook in which you created it; in other WORDS, the macro was not created in a way that EMBEDS it in all new workbooks. Is that right?


Discussion

No Comment Found

Related InterviewSolutions