Print Hyperlinked File, Move To Next

  • Column C (starting at row 5) contains hyperlinks. I want to print the linked file, move down to the next cell, print that file, move on to the next, etc. FYI - The worksheets are from a seperate file.

    Ed
    [SIZE=6]*ficus*[/SIZE]
    Thanks to all for making this website work!

  • Re: Print Hyperlinked File, Move To Next


    Are the applications referenced by the hyperlinks from a separate Excel workbook, or are they from another application altogether (e.g., TEXT, HTML, etc.)?


    If we're talking about other Excel workbooks being hyperlinked, this should work (but beware of auto-open macros). The code should begin with the sheet that has the hyperlinks selected.


  • Re: Print Hyperlinked File, Move To Next


    Thank you, I was able to get it working with just a few modifications.

    Ed
    [SIZE=6]*ficus*[/SIZE]
    Thanks to all for making this website work!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!