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: Oldest
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-10T02:59:37+00:00

    God bless you JLLatham. This was spot on and thanks for writing this for me. I also followed your instructions of how to write vba code and it worked..yuhoooo!

    I just need one small change. If a file already exists, I want to open the file for editing and not overwrite it.

    Eg: If I typed 'Coffee' in the first column and if a file called 'Coffee.xls' already exist, then just open it. Overwriting it looses changes done to the file previously. Is that simple enough to do.

    Was this answer helpful?

    0 comments
  3. 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

  4. 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
  5. 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