DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Macro to build hyperlink in Excel

  1. #1
    Join Date
    Feb 2009
    Posts
    3

    Macro to build hyperlink in Excel

    I export an Access Db Memo field to an Excel file that users research using a pivot table. The pivot table truncates the Memo field when you double-click for detail and loses the format of any hyperlink on double-click. I need a macro that will populate a hyperlink column in the detail tab after a double-click.
    I need to:
    count the total number of rows
    for each cell in column J build a hyperlink
    Something like:
    J2 =HYPERLINK(filepath,A2) for each row where filepath is a constant and A2 is my hyperlink description


  2. #2
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,663
    Start recording a macro
    Perform all of those steps above manually
    Stop recording the macro

    There is your programming code. It will need a few tweaks no doubt, but you will have the foundation for what you need.

Similar Threads

  1. Add Hyperlink in Excel
    By ratkinso in forum VB Classic
    Replies: 7
    Last Post: 01-25-2008, 11:54 AM
  2. help regarding excel macro!!
    By Farooko in forum VB Classic
    Replies: 1
    Last Post: 04-27-2007, 01:16 PM
  3. Replies: 1
    Last Post: 01-02-2007, 09:58 AM
  4. Using Word commands through an Excel macro
    By Pass0 in forum VB Classic
    Replies: 1
    Last Post: 10-24-2005, 01:26 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center