CodingCreating links to files - Excel 2007

 

Press Ctrl+Enter to quickly submit your post
Quick Reply  
 
 
  
 From:  ANT_THOMAS  
 To:  ALL
36035.1 
A friend of mine at uni has seen the database that I've made for all my uni data and wants something similar, but instead he'd like it to be a lot less complicated and he just wants a spreadsheet. He's asked me to help since he hasn't got a clue how to go about it and I would/should/might.

Anyway, looked at it and as ever it's actually far easier to "code" such a thing in PHP, but since we won't be using that it's hardly relevant.

What I want to do, I think, is fairly simple. Into the spreadsheet he will enter a code in one cell, eg:

2009-04-28-XX-45

He will then enter a number in the next cell, eg:

10

I want there to then be a link made in the following cell along the lines of:

file://c:/NMR/2009-04-28-XX-45/10/fid


I've thought about putting:

file://c:/NMR/

in one cell, and putting:

/fid

in another and then somehow combining them but I have no idea how to do so in Excel.

Will I need to use some sort of VBA? Please help!

0/0
 Reply   Quote More 

 From:  DazzW  
 To:  ANT_THOMAS     
36035.2 In reply to 36035.1 

I dunno, but, y'know, persevere.

 

I have a vague suspicion you need to look up CONCAT()

0/0
 Reply   Quote More 

 From:  koswix  
 To:  DazzW     
36035.3 In reply to 36035.2 
http://www.techonthenet.com/excel/formulas/concat.php


The Seventh Posture of Burton's translation of The Perfumed Garden is an unusual position not described in other classical sex manuals. The receiving partner lies on their side. The penetrating partner faces the receiver, straddling the receiver's lower leg, and lifts the receiver's upper leg on either side of the body onto the crook of penetrating partner's elbow or onto the shoulder. While some references describe this position as being "for acrobats and not to be taken seriously," others have found it very comfortable, especially during pregnancy.
0/0
 Reply   Quote More 

 From:  DazzW  
 To:  koswix     
36035.4 In reply to 36035.3 
Aye. You might want to tell him ^^^ though.
0/0
 Reply   Quote More 

 From:  koswix  
 To:  DazzW     
36035.5 In reply to 36035.4 
Nah, let the fucker work it out on his own.


The Seventh Posture of Burton's translation of The Perfumed Garden is an unusual position not described in other classical sex manuals. The receiving partner lies on their side. The penetrating partner faces the receiver, straddling the receiver's lower leg, and lifts the receiver's upper leg on either side of the body onto the crook of penetrating partner's elbow or onto the shoulder. While some references describe this position as being "for acrobats and not to be taken seriously," others have found it very comfortable, especially during pregnancy.
0/0
 Reply   Quote More 

Reply to All    
 

1–5

Rate my interest:

Adjust text size : Smaller 10 Larger

Beehive Forum 1.5.2 |  FAQ |  Docs |  Support |  Donate! ©2002 - 2024 Project Beehive Forum

Forum Stats