Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Brisbane, Australia
    Posts
    245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Hyperlink 1004 error (VBA/Excel/2003)

    I have a shared job register workbook that has VBA code for creating a hyperlink to related XLS files. This is done through a button on the worksheet.

    <pre>strSelect = Application.GetOpenFilename("MS Excel Files (*.xls), *.xls", _
    Title:="Please select file to be linked by navigating to it...")

    ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:=strSelect, TextToDisplay:="X"</pre>


    The problem is that it works fine BEFORE sharing is activated but then comes up with Run-time error '1004' after sharing is enabled.

    Can someone tell me what I need to look at so that the workbook can be used as intended with sharing turned on?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Hyperlink 1004 error (VBA/Excel/2003)

    Sharing a workbook is a recipe for disaster in my experience, the workbook becomes prone to corruption. I never use it any more.

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Brisbane, Australia
    Posts
    245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hyperlink 1004 error (VBA/Excel/2003)

    Thanks Hans, for your sage words of advice regarding shared workbooks. (A bit like Master Documents in Word? That was a dud for me. Never had a lot of success and actually corrupted about 6 chapters of a manual that a team was working on...)

    OK, can you tell me more about multiple users of documents? For the workbook in question I just assumed that it needed to be shared but this is how it is to be used.

    <UL><LI>Whilst more than one person may use the job register, they will generally be using a different worksheet.[/list]Does that cause any problems with more than one person opening it and then trying to save and close their session?

    What are your thoughts about separate workbooks with (dare I say it?) a "master workbook" that collates, via links, all the data? Individual sheets would be just linked to each of the line areas workbooks. Then only one person would need to open and view the "master" whilst individual line managers updated their own job registers.

    Would that work?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Hyperlink 1004 error (VBA/Excel/2003)

    If you don't use workbook sharing, only the first user who opens a workbook can edit it, all subsequent users open it read-only. It doesn't matter whether they look at the same worksheet or different worksheets.

    If you create a "master" workbook with links to various other workbooks, anyone can view this "master" while others are viewing or editing the other workbooks. But the changes won't be "live". If someone edits a workbook, it must be saved, then the user viewing the "master" must select Edit | Links..., Update Values. But I haven't seen corruption caused by this approach.

    If you really need multi-user capability, consider using a database application such as Access.

Posting Permissions

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