|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| ||||||||||||||||||||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Space in Excel Hyperlink
I did a search and did find a reference to this.
I have a hypelink which I run psinfo.exe on C drive. What I need to do is run the excutable with an argument like so. cell a1 = c:\psinfo\psinfo.exe cell b2 = \\computername (part one) cell c3 = computername (part two) The executable with argument is thus c:\psinfo\psinfo.exe \\computername (grabbing 3 parts of 3 different cells). Running at a dos prompt works fine and running the hyperlink with just the psinfo.exe without arguments runs fine. But when I add in the argument it breaks. So the hyperlink should look and does look like this =hyperlink(a1&b2&c3,"info") Except this doesn't give us the space, I can add the space several different ways including like this =HYPERLINK(CONCATENATE(a1," ",b2,c3),"info") And when I view the cell it shows that the space is there however it does not work. I get an error "Cannot open specified file." every time. I also tried to add quotes to no avail, I must be missing something. Any ideas? Thanks for your assistance. ![]() Last edited by Ronack : November 4th, 2009 at 11:46 AM. |
|
#2
|
|||
|
|||
|
Never mind, I've come up with an alternate solution.
Quote:
|
|
#3
|
||||
|
||||
|
Out of curiosity, what was your alternative solution ?
__________________
The No Ma'am commandments: 1.) It is O.K. to call hooters 'knockers' and sometimes snack trays 2.) It is wrong to be French 3.) It is O.K. to put all bad people in a giant meat grinder 4.) Lawyers, see rule 3 5.) It is O.K. to drive a gas guzzler if it helps you get babes 6.) Everyone should car pool but me 7.) Bring back the word 'stewardesses' 8.) Synchronized swimming is not a sport 9.) Mud wrestling is a sport |
![]() |
| Viewing: Dev Shed Forums > Operating Systems > Windows Help > Space in Excel Hyperlink |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|