Suggestions - New Version of Template

  • Thread starter Thread starter MrAlMackay
  • Start date Start date
M

MrAlMackay

I wondered if anyone would be able to offer advise on how to do the following
automatically through vba?

I currently have a spreadsheet (containing 6 sheets) that I need to update to a
'new' version of the spreadsheet.

The new version contains additional vba code within it and will also ensure
that all of the relevant cells contain the correct formulas etc.

What I want to be able to do is have a master spreadsheet that just contains a
box to enter the filename to update, and an update button which then loads the
new template - copies all data on to the new template and saves the new file to
the name of the 'old' file with _v2 @ the end.

Would anyone be able to offer any examples on how to do this?

Many Thanks in advance, Cheers - Al. ([email protected])
 
Al,

I can see a couple of methods to achieve this and which to use depends on
the additional code you wish to add.

Is the code located in a module? or is it within the sheets?

The simplest mehtod is to export the VBA module as a .bas file, and then
import it into the old sheet. This would be lot simpler than any other
method I can quickly think of.

Steve
 
Cheers Steve

The problem is that the new template will also ensure that all relevant cells
contain the correct formulas (when first issued, I must have missed some
formulas of the first version of the sheet) which didn't show up in my tests.

Will use the export of the module to export the code - it is within modules,
not within the sheets code.

Cheers for your help on this, Al Mackay.
 
Back
Top