We have several Excel Spreadsheets that are all in the same network
location. These are all controlled and owned by different people.
What we'd like is a way to display all the spreadsheets together in
one document such as a Word document or even another Excel spreadsheet
so that someone can open this one document and see the current
contents of all the spreadsheets. This "master" document does not
need to do anything except be able to display the Excel spreadsheets
(current) all together but they do not need to be all one spreadsheet
or linked to each other in any way.

I have been able to insert Objects into a Word doc of the files but
they come in all messed up for how much of the spreadsheet is
displayed and I can't seem to get a handle on how to control the
zooming in the Object window. I can also insert an Excel Spreadsheet
in it's own little object window with scroll bars but I can't seem to
get this type of display for an existing Excel spreadsheet.

Can't see us as being the only people ever wanting to do this. We'd
be happy if it was even an HTML webpage people could call up (in fact
would really prefer that).

Any help?

Hi

Try
http://www.rondebruin.nl/merge.htm

See also
http://msdn.microsoft.com/en-us/library/cc837974.aspx

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"infiniteMPG" <57classic@gmail.com> wrote in message news:24032802-df4f-4ac6-8632-ab4b3d15b7ba@2g2000hsn.googlegroups.com...
> We have several Excel Spreadsheets that are all in the same network
> location. These are all controlled and owned by different people.
> What we'd like is a way to display all the spreadsheets together in
> one document such as a Word document or even another Excel spreadsheet
> so that someone can open this one document and see the current
> contents of all the spreadsheets. This "master" document does not
> need to do anything except be able to display the Excel spreadsheets
> (current) all together but they do not need to be all one spreadsheet
> or linked to each other in any way.
>
> I have been able to insert Objects into a Word doc of the files but
> they come in all messed up for how much of the spreadsheet is
> displayed and I can't seem to get a handle on how to control the
> zooming in the Object window. I can also insert an Excel Spreadsheet
> in it's own little object window with scroll bars but I can't seem to
> get this type of display for an existing Excel spreadsheet.
>
> Can't see us as being the only people ever wanting to do this. We'd
> be happy if it was even an HTML webpage people could call up (in fact
> would really prefer that).
>
> Any help?

> Tryhttp://www.rondebruin.nl/merge.htm
> See alsohttp://msdn.microsoft.com/en-us/library/cc837974.aspx

Those look interesting but we need a single document that when opened
will update the displayed info from the other spreadsheets and the
displayed info needs to update whenever the sub-spreadsheets are
updated. We don't need to just create a merged document, we need to
create a document that just displays the current other documents in
it. It needs to be a living document so anytime it's opened, the data
is reloaded and current.

Use the Add-in or run the macro everytime you need the info
With formula links it is very diffecult to get all data from every workbook

What if you add or delete a workbook ?
How many rows of data are in every workbook ?

The Add-in or macro is much easier
When you need the data run the code or use the add-in


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"infiniteMPG" <57classic@gmail.com> wrote in message news:bc48a17d-f36f-4dbc-96b7-f1b4252f3fa2@m45g2000hsb.googlegroups.com...
>> Tryhttp://www.rondebruin.nl/merge.htm
>> See alsohttp://msdn.microsoft.com/en-us/library/cc837974.aspx
>
> Those look interesting but we need a single document that when opened
> will update the displayed info from the other spreadsheets and the
> displayed info needs to update whenever the sub-spreadsheets are
> updated. We don't need to just create a merged document, we need to
> create a document that just displays the current other documents in
> it. It needs to be a living document so anytime it's opened, the data
> is reloaded and current.
>
>