I have what is hopefully a simple request, but was unable to get enough
specific help with only the search function to complete this task
myself.

What I have:
I have a vendor-supplied bill of materials spreadsheet with part
numbers in a column. I want to single-click select any cell containing
a drawing number, then click one "button" with a hyperlink to open the
pdf drawing, based on the value of the selected active cell.

For the following example, the text displayed in the cell is "1234567"
and is the part number. My current hyperlink looks like this:
"http://cad.company.com/vault/AccessFile.asp?DrawingID=1234567&Source=FM&FileTyp e=PDF"

My question(s) is/a
What is the proper syntax to obtain the active cell value and replace
it in the hyperlink? Is it even possible?


I know I could set up separate hyperlinks for each cell, but I would
like to do it this way to save time and reduce errors. (I do not know
VBA, yet.)

Thanks!


--
chevee55
------------------------------------------------------------------------
chevee55's Profile: http://www.excelforum.com/member.php...o&userid=32309
View this thread: http://www.excelforum.com/showthread...hreadid=520645

Hi chevee55

Try this with in A1 the number

=HYPERLINK("http://cad.company.com/vault/AccessFile.asp?DrawingID=" & A1 &"&Source=FM&FileType=PDF")


--
Regards Ron de Bruin
http://www.rondebruin.nl


"chevee55" wrote in message
...

I have what is hopefully a simple request, but was unable to get enough
specific help with only the search function to complete this task
myself.

What I have:
I have a vendor-supplied bill of materials spreadsheet with part
numbers in a column. I want to single-click select any cell containing
a drawing number, then click one "button" with a hyperlink to open the
pdf drawing, based on the value of the selected active cell.

For the following example, the text displayed in the cell is "1234567"
and is the part number. My current hyperlink looks like this:
"http://cad.company.com/vault/AccessFile.asp?DrawingID=1234567&Source=FM&FileTyp e=PDF"

My question(s) is/a
What is the proper syntax to obtain the active cell value and replace
it in the hyperlink? Is it even possible?


I know I could set up separate hyperlinks for each cell, but I would
like to do it this way to save time and reduce errors. (I do not know
VBA, yet.)

Thanks!


--
chevee55
------------------------------------------------------------------------
chevee55's Profile: http://www.excelforum.com/member.php...o&userid=32309
View this thread: http://www.excelforum.com/showthread...hreadid=520645

I would remove the hyperlink from that cell and use this in the cell to its
right:

=hyperlink("http://cad.company.com/vault/AccessFile.asp?DrawingID=" & A1
& "&Source=FM&FileType=PDF", A1)

(all one cell)

chevee55 wrote:

I have what is hopefully a simple request, but was unable to get enough
specific help with only the search function to complete this task
myself.

What I have:
I have a vendor-supplied bill of materials spreadsheet with part
numbers in a column. I want to single-click select any cell containing
a drawing number, then click one "button" with a hyperlink to open the
pdf drawing, based on the value of the selected active cell.

For the following example, the text displayed in the cell is "1234567"
and is the part number. My current hyperlink looks like this:
"http://cad.company.com/vault/AccessFile.asp?DrawingID=1234567&Source=FM&FileTyp e=PDF"

My question(s) is/a
What is the proper syntax to obtain the active cell value and replace
it in the hyperlink? Is it even possible?

I know I could set up separate hyperlinks for each cell, but I would
like to do it this way to save time and reduce errors. (I do not know
VBA, yet.)

Thanks!

--
chevee55
------------------------------------------------------------------------
chevee55's Profile: http://www.excelforum.com/member.php...o&userid=32309
View this thread: http://www.excelforum.com/showthread...hreadid=520645

--

Dave Peterson

Thank you for the replies, and it coincides with my search results. I
had tried it, but the cell call-out gets converted to
"%22%20&%20A1%20&%20%22", so the hyperlink fails.

However, I will clarify my question further, in that I want the
hyperlink to be variable, to handle whatever cell I select. It would
automatically "grab" the contents of the active cell that I have
single-clicked on, and make that part of the hyperlink path.
Is that possible without resorting to VBA?


--
chevee55
------------------------------------------------------------------------
chevee55's Profile: http://www.excelforum.com/member.php...o&userid=32309
View this thread: http://www.excelforum.com/showthread...hreadid=520645

I don't think so.



chevee55 wrote:

Thank you for the replies, and it coincides with my search results. I
had tried it, but the cell call-out gets converted to
"%22%20&%20A1%20&%20%22", so the hyperlink fails.

However, I will clarify my question further, in that I want the
hyperlink to be variable, to handle whatever cell I select. It would
automatically "grab" the contents of the active cell that I have
single-clicked on, and make that part of the hyperlink path.
Is that possible without resorting to VBA?

--
chevee55
------------------------------------------------------------------------
chevee55's Profile: http://www.excelforum.com/member.php...o&userid=32309
View this thread: http://www.excelforum.com/showthread...hreadid=520645

--

Dave Peterson