Need some Expertise! Did I come to the right place?

charlie79 · Apr 3rd, 2002, 11:23 AM

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 ]

Jack in the UK · Apr 3rd, 2002, 11:31 AM

Hi

Might be wrong but suggest binder!

If 3 xls files or 3 office relatted programs matter not!

charlie79 · Apr 4th, 2002, 06:46 AM

Seemed like the best solution at the time. But, upon investigation I found that Binder does not handle macros/vba very well. I seem to be getting some runtime errors that I wasn't gettting when running from xl. Any other suggestions??

Jack in the UK · Apr 4th, 2002, 11:34 AM

Hi

Still go with Binder but VBA is EXCEL only, word has word basic...

Binder has own VBA as such a little different... run time is just some part of the code it dont like debug to find the line effected and post might be simple amendment

Apr 3rd, 2002, 11:31 AM	#2
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	Hi Might be wrong but suggest binder! If 3 xls files or 3 office relatted programs matter not! __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Apr 4th, 2002, 11:34 AM	#4
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	Hi Still go with Binder but VBA is EXCEL only, word has word basic... Binder has own VBA as such a little different... run time is just some part of the code it dont like debug to find the line effected and post might be simple amendment __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 3rd, 2002, 11:23 AM	#1
charlie79 Board Regular Join Date: Feb 2002 Posts: 97	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 ]

Apr 4th, 2002, 06:46 AM	#3
charlie79 Board Regular Join Date: Feb 2002 Posts: 97	Seemed like the best solution at the time. But, upon investigation I found that Binder does not handle macros/vba very well. I seem to be getting some runtime errors that I wasn't gettting when running from xl. Any other suggestions??