Format Cells --> Hyperlink

  • Thread starter Thread starter Duncan Anderson
  • Start date Start date
D

Duncan Anderson

I might have chosen the wrong N/Gs for this enquiry, if so please accept my
apologies.

I use WebFerret a lot to search the Internet. Occasionally I E-mail the results
to a friend who's been searching for something. WebFerret will export its
results to a .csv file which the recipient can open with their spreadsheet
application if they don't have WebFerret.

To make life easier for my friends I'd like to change the contents of the cells
into hyperlinks. This would require that I send a .xls file to my friends, but
that would be a small sacrifice of bandwidth for functionality gained.

I've got two options. The first is to use the contents of the cell as the
hyperlink. The second is slightly more complicated, to use the contents of the
cell in column B as the hyperlink of the cell in column A, whilst keeping the
contents of the cell in column A unchanged.

If I only had to make on or two changes, I'd do them manually. But with 100+
rows to alter I was hoping for an easier method. Either through Excel
functionality or VBA.

I'm using Excel2ksp2 with all up-dates from MS.

Any help or suggestions would be useful.


TIA
Duncan Anderson
 
How about sending an ImportTheCSV.xls file?

You send this once and if the .csv files are always the same format, your import
macro can do as much formatting (headers/footers/page layout, etc) as well as
add the links.

Then every time you send the .csv file, you tell them to open the
ImportTheCSV.xls file and click on the big button that runs the macro to import
the file.

Even if the resulting xls file were small, you might like to use your macro to
create it. (I've found that sending .xls files is sometimes easier than
explaining what to do. The additional bytes (kilo, not mega) don't bother me
anymore.)
 
Back
Top