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:\Pr ogram 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