Hyperlink Text in a Excel Row Automatically

Anonymous
2011-10-09T03:53:11+00:00

I have one excel sheet called product.xls and an Excel template with product detail fields.

I open this excel sheet. Whatever I type in the first column, should get converted to a hyperlink. So let's say I typed 'Roger' in A6. Roger should be hyperlinked. On clicking 'Roger' a new file with the name of Roger should be created  in a folder, using the template, and this new file should open for the user to edit. If the same filename as Roger already exists, open existing file.

Is this possible in Excel? My friend told you need something called VBA but I am so clueless that you guys are my only step-by-step help!

Thanks for reading this.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

8 answers

Sort by: Newest
Most helpful Newest Oldest
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  2. Anonymous
    2011-10-11T02:17:18+00:00

    Thanks. If a file with the same name already exists and I type that name in the first column, it gives me an error

    Run-time error '1004':

    "" could not be found. Check spelling of the file name and verify location

    Any idea what's causing it?

    Was this answer helpful?

    0 comments
  3. Anonymous
    2011-10-10T13:07:53+00:00

    Glad it's working now.  Let me know if it doesn't work as you wanted.  I made these last changes without actually testing them.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2011-10-10T10:13:12+00:00

    never mind looks like macros were getting disabled automatically when the excel file was opened each time.

    Was this answer helpful?

    0 comments
  5. Anonymous
    2011-10-10T09:16:37+00:00

    Strangely the code runs well when the excel file is opened for the first time. When I close the excel file and open it again, nothing happens on typing in the first column. Right click > view code shows the code is there!

    Any idea what could be happening.

    My excel sheet is Products.xls and template is ProductDet.xlt

    Was this answer helpful?

    0 comments