File name In Hyperlink

[stew]

Hi all

The Formula below allows me to open my scanner from the spreadsheet.

=IF(AND(SUM(C10:E10)>0,$B$6="No"),HYPERLINK("C:\Program Files\Canon\CanoScan
Toolbox Ver4.9\CSTBox.exe","Scan And Name"&" "&ROW()-1&" "&"To Income
Receipts")," ")

I would like to replace the

"C:\Program Files\Canon\CanoScan Toolbox Ver4.9\CSTBox.exe",

part with a cell Number which will contain the above information or if
somebody is using a different scanner they would insert there file path in
said cell.

Can Somebody indicate how I would tie this together

Thanks for looking

Stewart

 

[Sheeloo]

Simply replace
"C:\Program Files\Canon\CanoScan Toolbox Ver4.9\CSTBox.exe"
with the address of the Cell containing
C:\Program Files\Canon\CanoScan Toolbox Ver4.9\CSTBox.exe

If A1 contains
C:\Program Files\Canon\CanoScan Toolbox Ver4.9\CSTBox.exe
then use
=IF(AND(SUM(C10:E10)>0,$B$6="No"),HYPERLINK(A1,"Scan And Name"&" "&ROW()-1&"
"&"To Income
Receipts")," ")

in your formula

=IF(AND(SUM(C10:E10)>0,$B$6="No"),HYPERLINK("C:\Program Files\Canon\CanoScan
Toolbox Ver4.9\CSTBox.exe","Scan And Name"&" "&ROW()-1&" "&"To Income
Receipts")," ")

 

[stew]

Thank You Sheeloo

Stew

Simply replace
"C:\Program Files\Canon\CanoScan Toolbox Ver4.9\CSTBox.exe"
with the address of the Cell containing
C:\Program Files\Canon\CanoScan Toolbox Ver4.9\CSTBox.exe

If A1 contains
C:\Program Files\Canon\CanoScan Toolbox Ver4.9\CSTBox.exe
then use
=IF(AND(SUM(C10:E10)>0,$B$6="No"),HYPERLINK(A1,"Scan And Name"&" "&ROW()-1&"
"&"To Income
Receipts")," ")

in your formula

=IF(AND(SUM(C10:E10)>0,$B$6="No"),HYPERLINK("C:\Program Files\Canon\CanoScan
Toolbox Ver4.9\CSTBox.exe","Scan And Name"&" "&ROW()-1&" "&"To Income
Receipts")," ")