Windows Help
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsOperating SystemsWindows Help

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old November 4th, 2009, 11:42 AM
Ronack Ronack is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Sep 2004
Posts: 301 Ronack User rank is Corporal (100 - 500 Reputation Level)Ronack User rank is Corporal (100 - 500 Reputation Level)Ronack User rank is Corporal (100 - 500 Reputation Level)Ronack User rank is Corporal (100 - 500 Reputation Level) 
Time spent in forums: 1 Day 21 h 19 m 46 sec
Reputation Power: 7
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.

Reply With Quote
  #2  
Old November 5th, 2009, 01:19 PM
Ronack Ronack is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Sep 2004
Posts: 301 Ronack User rank is Corporal (100 - 500 Reputation Level)Ronack User rank is Corporal (100 - 500 Reputation Level)Ronack User rank is Corporal (100 - 500 Reputation Level)Ronack User rank is Corporal (100 - 500 Reputation Level) 
Time spent in forums: 1 Day 21 h 19 m 46 sec
Reputation Power: 7
Never mind, I've come up with an alternate solution.

Quote:
Originally Posted by Ronack
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.

Reply With Quote
  #3  
Old November 6th, 2009, 01:00 PM
aitken325i's Avatar
aitken325i aitken325i is offline
Providing fuel for space ships
Dev Shed God 19th Plane (14000 - 14499 posts)
 
Join Date: Mar 2004
Location: nr Edinburgh, Scotland
Posts: 14,052 aitken325i User rank is General 33rd Grade (Above 100000 Reputation Level)aitken325i User rank is General 33rd Grade (Above 100000 Reputation Level)aitken325i User rank is General 33rd Grade (Above 100000 Reputation Level)aitken325i User rank is General 33rd Grade (Above 100000 Reputation Level)aitken325i User rank is General 33rd Grade (Above 100000 Reputation Level)aitken325i User rank is General 33rd Grade (Above 100000 Reputation Level)aitken325i User rank is General 33rd Grade (Above 100000 Reputation Level)aitken325i User rank is General 33rd Grade (Above 100000 Reputation Level)aitken325i User rank is General 33rd Grade (Above 100000 Reputation Level)aitken325i User rank is General 33rd Grade (Above 100000 Reputation Level)aitken325i User rank is General 33rd Grade (Above 100000 Reputation Level)aitken325i User rank is General 33rd Grade (Above 100000 Reputation Level)aitken325i User rank is General 33rd Grade (Above 100000 Reputation Level)aitken325i User rank is General 33rd Grade (Above 100000 Reputation Level)aitken325i User rank is General 33rd Grade (Above 100000 Reputation Level)aitken325i User rank is General 33rd Grade (Above 100000 Reputation Level)  Folding Points: 10110 Folding Title: Novice Folder
Time spent in forums: 5 Months 3 Weeks 3 Days 11 h 11 m 38 sec
Reputation Power: 3179
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

Reply With Quote
Reply

Viewing: Dev Shed ForumsOperating SystemsWindows Help > Space in Excel Hyperlink


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump




 Free IT White Papers!
 
How to Present Effectively Online
This white paper offers practical and actionable advice on the key steps that any presenter should consider as they plan and execute a Webinar or online meeting.

 
Open Source Security Myths
Open Source Software (OSS) is computer software whose source code is available to the general public with relaxed or non-existent intellectual property restrictions (or arrangement such as the public domain), and is usually developed with the input of many contributors.

 
Power and Cooling Capacity Management for Data Centers
This paper describes the principles for achieving power and cooling capacity management.

 
Scalable, Fault-Tolerant NAS for Oracle - The Next Generation
For several years NAS has been evolving as a storage alternative for Oracle databases, and for good reason: NAS is quite often the simplest, most cost-effective storage approach for Oracle. Learn about the benefits that HP's approach to scalable NAS brings to Oracle environments in this comprehensive white paper.

 
Understanding Web Application Security Challenges
This white paper discusses many common threats and preventive measures for Web application security, and explains what you can do to help protect your organization.

 

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 




© 2003-2009 by Developer Shed. All rights reserved. DS Cluster 6 Hosted by Hostway
For more Enterprise Application Development news, visit eWeek