Here's the situation. I have three seperate excel apps (xl2k). Each app is very similar to the other, especially when comparing the vba code behind the scenes. These three apps will be administered by one or more persons, and that's were my question lies. I would like to have one workbook that contains the sheet (there is only one) from all three apps, as well as having an additional sheet for administrative duties. I don't want to copy these sheets into a new workbook, as there will probably be many updates incurred on the three apps from time to time. Ideally, I want something like in Access, were you can link to a table from another db, only in this case, it would be linking to a sheet in another excel workbook.
Ideas anyone?
Sorry, after reading the original post I would like to clarify something. When I say "There is only one" from all three apps, I mean, there is only one sheet in each app and I would like to include each one in the administrative workbook.
This message was edited by charlie79 on 2002-04-03 10:26
Ideas anyone?
Sorry, after reading the original post I would like to clarify something. When I say "There is only one" from all three apps, I mean, there is only one sheet in each app and I would like to include each one in the administrative workbook.
This message was edited by charlie79 on 2002-04-03 10:26