| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| why is absolute hyperlink in XLS file changed when file is saved | Excel Discussion (Misc queries) | |||
| hyperlink to .png file | Excel Worksheet Functions | |||
| Hyperlink to PDF file. | Excel Discussion (Misc queries) | |||
| Turning a text file name into a search and linking the file as a hyperlink | Excel Discussion (Misc queries) | |||
| Hyperlink to a file | Excel Discussion (Misc queries) | |||
Linear Mode
