software

What should I do to generate one new file automaticaly on change some values
of some cells?
For example, I have a file xpto.xls that is a template. with three cells:
A1, A2 and A3. When I change the values of this cells, I want that another
file, for example xpto1.xls, be generated.
At the same time, I need to update another file, for example ResumeXPTO.xls
tha contains the names of all files generated and a cell with a link for each
one.
Thanks.

First, I don't think I would ever generate a file automatically when the user
changes a cell. There's just too much chance that there's a typo and the user
will have to correct it (several times???).

Then I'd end up with lots of files--maybe overwriting good files with typos.

But I would put a button on that worksheet next to the three cells that would
allow the user to click the button when they're ready to create those workbooks.

I'd record a macro when I did the saveAs manually to get the code--maybe you
want savecopyas (so the original doesn't change???). But you'll have to change
that in your code.

Post back after you've tried recording the steps and have questions.

As for the other workbook, I'd record that macro when I opened the
resumexpto.xls file and updated it, too.

M. Neves wrote:
gt;
gt; What should I do to generate one new file automaticaly on change some values
gt; of some cells?
gt; For example, I have a file xpto.xls that is a template. with three cells:
gt; A1, A2 and A3. When I change the values of this cells, I want that another
gt; file, for example xpto1.xls, be generated.
gt; At the same time, I need to update another file, for example ResumeXPTO.xls
gt; tha contains the names of all files generated and a cell with a link for each
gt; one.
gt; Thanks.

--

Dave Peterson