Hi

Thanks for pointing this out. Having thought about it some more.
Basically, I create a list of actions on an Excel spreadsheet. Then I save
this on a network drive and give it a file name, Upgrade.xls.

Then in a totally different workbook, I have created a simple appointment
system. A form on this appointment system will want the hyperlink for the
file name to be added to Sheet 1, from cell reference H5 onwards, so that
when clicking the hyperlink, the Upgrade.xls document will open up.

Am I making sense? If so, please can you help me in any way.

Thank you very much


"JLGWhiz" wrote:

I can't help you with the browse and select bit, but thought I would point
out that uploading is when you send data to another system and downloading is
when you receive data from another system. I could be wrong but I think you
want to download. You need to be a little more specific about what type of
file liike text or data or chart and where it comes from, like webpage,
access, DB4, other Excel, etc.


"zak" wrote:

Hi

I am creating a form in excel, and one of the prompts on the form is to
browse and upload a file (like any other upload file function where you can
just browse and upload). What i would like to do is to be able to just click
on the 'browse' button and select the file, then for the file path to be
copied into excel as just a hyperlink (so that when you click on that
hyperlink, it will open up the file).

I don't know if this is at all feasable or not...can anyone help/advise me?

Thank you