Automated Excel, Fill from other file & save (html)

[Tom Robertson]

Is it possible to create an Excel file which will
automatically fill cells with results from other cells of
another excel file.

Is it possible to automate this, as well as automate
saving the file as a webpage?

A macro?

Reards,

Tom

 

[Dave Peterson]

Depends on what you mean by: "automatically fill"

You could open the second workbook and copy the data from one worksheet and
paste into the original worksheet.

You could fill the cells of the original worksheet with formulas that point back
to that first workbook/worksheet.

=IF('C:\My Documents\excel\[book2.xls]Sheet1'!A1="","",
'C:\My Documents\excel\[book2.xls]Sheet1'!A1)

And fill up that worksheet with similar formulas.

======
And if you record a macro when you save the file the way you want (.html??),
you'll be closer to to done.