I'm trying to write a routine to update some remote templates by pasting
information from another workbook. The templates are designed to run a
userform to accept input but, for the purposes of the update, I don't want
these to run.

Is there a way to open a template from code in another workbook without
allowing the code in the template to run?

I can see 3 possible options:
1. Stop the code running in the template
2. Allow the template code to run, but automatically actuate the Cancel
button (CommandButton2) on the userform
3. Paste from the workbook to the template without opening the template

I can't find a way to do any of these, nor do I know if they are possible.

I've tried recording a macro in the hope of working through this, but the
part where I click to disable macros when the template opens doesn't produce
any code.

Any pointers will be welcome

Ian,

Turn off events:

Application.EnableEvents = False
Workbooks.Open "C:\Folder\FileName.xls"
Application.EnableEvents = True

HTH,
Bernie
MS Excel MVP


"Ian" wrote in message ...
I'm trying to write a routine to update some remote templates by pasting information from another
workbook. The templates are designed to run a userform to accept input but, for the purposes of
the update, I don't want these to run.

Is there a way to open a template from code in another workbook without allowing the code in the
template to run?

I can see 3 possible options:
1. Stop the code running in the template
2. Allow the template code to run, but automatically actuate the Cancel button (CommandButton2) on
the userform
3. Paste from the workbook to the template without opening the template

I can't find a way to do any of these, nor do I know if they are possible.

I've tried recording a macro in the hope of working through this, but the part where I click to
disable macros when the template opens doesn't produce any code.

Any pointers will be welcome

That easy, eh?

Thanks, Bernie.

Ian

"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
Ian,

Turn off events:

Application.EnableEvents = False
Workbooks.Open "C:\Folder\FileName.xls"
Application.EnableEvents = True

HTH,
Bernie
MS Excel MVP


"Ian" wrote in message
...
I'm trying to write a routine to update some remote templates by pasting
information from another workbook. The templates are designed to run a
userform to accept input but, for the purposes of the update, I don't
want these to run.

Is there a way to open a template from code in another workbook without
allowing the code in the template to run?

I can see 3 possible options:
1. Stop the code running in the template
2. Allow the template code to run, but automatically actuate the Cancel
button (CommandButton2) on the userform
3. Paste from the workbook to the template without opening the template

I can't find a way to do any of these, nor do I know if they are
possible.

I've tried recording a macro in the hope of working through this, but the
part where I click to disable macros when the template opens doesn't
produce any code.

Any pointers will be welcome