Need some Expertise! Did I come to the right place?
Need some Expertise!  Did I come to the right place?
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

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

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    97
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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 ]

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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"

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    97
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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??

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    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"

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com