File name In Hyperlink
 

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

File name In Hyperlink
 

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,"Sc an And Name"&" "&ROW()-1&"
"&"To Income
Receipts")," ")

in your formula

=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")," ")


"stew" wrote:

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

File name In Hyperlink
 

Thank You Sheeloo

Stew

"Sheeloo" wrote:

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,"Sc an And Name"&" "&ROW()-1&"
"&"To Income
Receipts")," ")

in your formula

=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")," ")


"stew" wrote:

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