MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Copying from a master spreadsheet to a new workbook

  Asked By: Gin    Date: Sep 22    Category: MS Office    Views: 1703

I have created a workbook which is 2 sheets a template worksheet and then some
parameters and a vba button.

I have been able to create the copy and customising of a each new sheet based on
a template successfully.

The next step I am unsure of how I can control (ie the correct vba commands) I
now wish to do the same task but create a new workbook (which i have done).

1) How do I refer to the new workbook via the vba code?
2) How do I copy between the first workbook and the new workbook?

This is to ensure that the new workbook doesn't have the macros and code in it
and thus will not will require certificate or anything special for users to use

It's more a lack of syntax than a programming issue so hopefully someone can
point me in the right direction.



No Answers Found. Be the First, To Post Answer.

Didn't find what you were looking for? Find more on Copying from a master spreadsheet to a new workbook Or get search suggestion and latest updates.