Convert into hyperlink

Posted on 2003-02-26
Medium Priority
Last Modified: 2011-09-20
Hi all,

I got a Access database table with one of its table storing :
as text, the filed name lets say is folder_path

then i use the 'worksheets("Sheet1").CopyFromRecordset rs' to paste the whole table onto sheet1, where rs is the recordset having the query result

my problem is... i need to let user to click on the folder_path and it will automatically open up the folder, however the 'file:///E:/Temp/' appear as a normal text in Excel, which i cannot click on it as a hyperlink

wat should i do to format the cell to show the text as hyperlink? it has to be done in code and dynamically.

Thanks a lot.
Question by:KCChan
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
LVL 22

Expert Comment

ID: 8030943
Paths are not seen automatically as valid hyperlinks in Excel.

You may need a loop-type macro that you can run on this stuff to turn it into a hyperlink.

Accepted Solution

Rajmafia earned 200 total points
ID: 8031016
You can try by recording a macro function... the result is something like this:
   ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _
this code does link an Excel worksheet. maybe can try this to link an access db.

Author Comment

ID: 8031499
It works, thanks. :)


Expert Comment

ID: 8032286
You're welcome. Tk cr. :)

Featured Post

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
My attempt to use PowerShell and other great resources found online to simplify the deployment of Office 365 ProPlus client components to any workstation that needs it, regardless of existing Office components that may be needing attention.
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question