Create a Hypertexting loop.

Microsoft Excel 2003 (full product)
May 2, 2010 at 08:52:13
Specs: Windows XP
I X number of cells which have the actual file path in text format. I would like a macro that converts the filepath and replaces the text in the same cell. When it reaches "" null (no text), ends macro.

For example if cell A2 contains "C:\MyDocuments\TestDoc01.doc"
then have cell A2 will contain hyperlink to that document.

See More: Create a Hypertexting loop.

May 2, 2010 at 09:33:59
re: I would like a macro...

We all would like something.

Sometimes we have to actually ask, nicely, for what we want.

We're all just volunteers here, giving up our own free time to help others. It's much more courteous to ask for help than to just tell us what you would like.

Report •
Related Solutions

Ask Question