I have a worksheet with a column of hyperlinks to pictures
(http://server/image.jpg, http://server/image2.jpg, etc.)
I would like to create a macro which replaces all the hyperlinks with
the actual pictures, or inserts them into an adjacent cell.

I want to create external links in a bunch of excel files (50-100) to one
central workbook with lookup tables.  Is there any tricky way to make the
sheets search for the lookup table workbook (such as by name) in the event
the file structure changes, i.e. if the file are moved ...

I am having 12 files in different network locations. Each having one
worksheet inside. I just want to know whether I can create one file in my
hard drive and create 12 worksheets and Import External Data to each
worksheet from the different files so that I can see all of those ...

Say I have my excel sheet on the Desktop. And I want to link to two
documents in "My Documents".
I go to a cell, right click, hyperlink, get a box that says "Insert
Hyperlink", this box shows my Desktop so I browse to "My Documents",

I am attempting to link a few Excel files to a worksheet in a separate file
that contains my master data.   The link works, but, empty cells in the range
selected now contain a zero,  in the target files.  How do I prevent cells
from being zero filled?  I have set columns to TEXT ...

Hi group,
I often re-use good workbooks that need only minor modofication to fit
for a similar project.
One problem I have run into several times is when Excel gives me a

Hi can you help i have a range of numbers and need to insert a zero in front
is there a way of doing this
sample
07011117050

i need to insert a zero in front of a range of numbers
7011117050
7011117051
7011117052

I have a spreadsheet that contains a list of numerical values (i.e.) along
with other data.
App NO      Type   Title                  etc.
5963369    Cats     The cat's life

How can I link cells from multiple workbooks into 1 workbook?
I want to link information from many workbooks into 1 workbook to make
a sumary of all the information.
All help will be apretiated.

I haven't been able to find a way to do this in the Help resources I found
so far:
I'd like to have a "report" workbook importing data from a number of other
"data" workbooks. I can make the external references manually, but that would

Excel 2003.  I have workbooks in which there are internal links (cell
references and references to labeled cells).  I would like to "freeze" these
before copying these sheets to another workbook.  How can I resolve the
internal links or references so that the references are no ...

This request involves Outlook 2003 and Excel 2003.
I send "cut & pasted" Excel spreadsheet data to various mail recipients
via  HTML messages.  Since I run multiple computers on my network,  I
also have an add-in app that BCCs all my messages back to me.  In order

In Office 2000, I have links to cells in an Excel list. When the list is
sorted, the links remain to the cell references, so show different data.  I
want the links to follow the data when it is sorted, so I guess I somehow
need to link to data and not cells.

I want to link Row 3 in workbookA to Row 5 in workbookB.  In WorkbookB cell
A5 I  have:
=+[WorkbookA.xls]Sheet1!$A$3
The links are working except when I insert a row above Row 3 in WorkbookA.