What's that? You wanna chit chat? Welcome to the whore thread!

[///M Power-Belgium]

Originally Posted by Aatish

My sinuses have been better. Weather switching from cold to hot to cold is not helping.

Yeah I see...

Think my sinuses are otherwise ...I'm suffering from my sinuses in the last 6-7 years ,summer and winter ! Doctors say I need a sinus surgery .
Personal I think it comes from my work stress !
But I'm chicken because I saw a sinus surgery on the Internet ...
Think it was a mistake to watch the horror .

Every night before sleeping I need this shit...

[nyalpine90]

sup peeps

[Axius]

Doing shit around the house, packing, gotta get about 5 more bags of mulch, filter for the hallway, smoke detector, and some other shit.

Sup wit yall

[Aatish]

Fucking windy.

[Axius]

Oh doorbell chime decided to stop working have to replace that also.

[///M Power-Belgium]

Originally Posted by Axius

Oh doorbell chime decided to stop working have to replace that also.

William ...It's *Murphy's law* !

[///M Power-Belgium]

Originally Posted by Aatish

Fucking windy.

Bhai ....You ?

[///M Power-Belgium]

[Aatish]

Originally Posted by ///M Power-Belgium

Bhai ....You ?

The weather. Cold and windy.

[nyalpine90]

some crazy weather past few days

[Mr Tonka]

Originally Posted by Axius

Doing shit around the house, packing, gotta get about 5 more bags of mulch, filter for the hallway, smoke detector, and some other shit.

Sup wit yall

Originally Posted by Axius

Oh doorbell chime decided to stop working have to replace that also.

Getting ready for it to hit the market?

[Axius]

Originally Posted by ///M Power-Belgium

William ...It's *Murphy's law* !

wat?

Originally Posted by Mr Tonka

Getting ready for it to hit the market?

Yeah, trying to spiffin the place up a bit, make sure everything works that I didn't really care about.

Really sucks leaving this house behind, love the house and my neighbors are awesome.

[///M Power-Belgium]

Originally Posted by Axius

wat?

=> https://en.wikipedia.org/wiki/Murphy's_law

[Axius]

Originally Posted by ///M Power-Belgium

=> https://en.wikipedia.org/wiki/Murphy's_law

Billup's Law -

Nothing can go wrong unless you allow it you.

[nyalpine90]

[UncleWede]

So Excel peeps: how do I make the contents of a column that contains the name of the exported file actually be the link to the file so I (or the judge) can pull up the images of the checks direct from each line? It has to somehow include ".\" so it can travel as a folder across thumb drives.

[Biorin]

Originally Posted by UncleWede

So Excel peeps: how do I make the contents of a column that contains the name of the exported file actually be the link to the file so I (or the judge) can pull up the images of the checks direct from each line? It has to somehow include ".\" so it can travel as a folder across thumb drives.

Does right click --> insert hyperlink --> *select your file* serve this purpose for you? Not 100% with what you're trying to achieve with the naming convention.

[UncleWede]

Originally Posted by Biorin

Does right click --> insert hyperlink --> *select your file* serve this purpose for you? Not 100% with what you're trying to achieve with the naming convention.

I don't want to have to select them all individually, they are already in a column as the name of the associated file, but they aren't currently a link, just text..

The .\ is "current folder" so I don't end up selecting "C:\my user profile\documents\subfolder\subfolder\filename" which the judge may not have on his computer.

[Biorin]

Originally Posted by UncleWede

I don't want to have to select them all individually, they are already in a column as the name of the associated file, but they aren't currently a link, just text..

The .\ is "current folder" so I don't end up selecting "C:\my user profile\documents\subfolder\subfolder\filename" which the judge may not have on his computer.

Ahh, okay. I'm probably useless then.

[Axius]

Make a pivot table!

[Joekerr]

Originally Posted by UncleWede

So Excel peeps: how do I make the contents of a column that contains the name of the exported file actually be the link to the file so I (or the judge) can pull up the images of the checks direct from each line? It has to somehow include ".\" so it can travel as a folder across thumb drives.

I seriously wanted to make a comment regarding the judge, goats and you, but I'm standing strong against temptation.

I'm not certain you can do what you want to do, to be honest. Someone more talented than me perhaps will know. The only thing I could think of would be to save the images to the USB key first and then create the file links to the USB key images. But I'm not even sure that would work, because depending on what USB devices are used on the computer it is going to, it could rename the USB key used from say E:\ to F:\ and I'm not sure if the links would still be valid then. Sorry - only idea I could come up with.

[RJ_]

Originally Posted by UncleWede

I don't want to have to select them all individually, they are already in a column as the name of the associated file, but they aren't currently a link, just text..

The .\ is "current folder" so I don't end up selecting "C:\my user profile\documents\subfolder\subfolder\filename" which the judge may not have on his computer.

Sub hyperlink()
'
' hyperlink Macro
'
' Keyboard Shortcut: Ctrl+h
'

Dim cl As Range
Dim s As String
Dim wede As String

wede = "fugitive"

For Each cl In Selection
    cl.Select
    s = cl.Value
    ActiveCell.Offset(0, 1).Hyperlinks.Add Anchor:=ActiveCell.Offset(0, 1), Address:=s, TextToDisplay:=s
    
Next cl

wede = "Acquitted"
    
End Sub

Press Alt + F11
Paste this into your macro module
In your spreadsheet, select the list of paths that you want to make hyperlinks.
Press ctrl + h

*Notes
- DON'T use column select, pretty sure that will make an infinite loop. This is untested and you get what you pay for.
- This is going to overwrite the column one to the RIGHT of your path list. Make sure it's blank or you gon' lose data.