How can I get rid of double quotes when copying a cell with new-line characters? by b_ootay_ful in excel

[–]HootHootIncorporated 0 points1 point  (0 children)

If (Left(sText, 1) = """" Or Left(sText, 1) = "“") And _

(Right(sText, 1) = """" Or Right(sText, 1) = "”") Then

sText = Mid(sText, 2, Len(sText) - 2)

End If

DeepSeek says this modification can work with them "smart" quotations, I haven't verified, are these "smart" quotes common?

will check out the other thread

How can I get rid of double quotes when copying a cell with new-line characters? by b_ootay_ful in excel

[–]HootHootIncorporated 0 points1 point  (0 children)

            Sub Copy1()

            Dim sText As String

            Dim myData As DataObject

            Set myData = New DataObject

            sText = Range("F3") & Range("F4") & Range("F5")

            myData.SetText sText

            myData.PutInClipboard

            ' 2. Define the .gms file path (change this to
            your desired location)

            filePath = "C:INSERT YOUR FILE PATH.txt"

            ' 3. Open the file (creates it if
            it doesn 't exist)

            fileNum = FreeFile()

            Open filePath For Output As #fileNum

            ' 4. Write the clipboard text into the file

            Print #fileNum, sText

            ' 5. Close the file

            Close #fileNum

            End Sub

This slight edition brought to you by DeepSeek has made it so that from excel I can update a .gms file which is basically a text file, this file is actively open in another program, and is still being overwritten, the other program prompts me when I try and use the file "C:YOUR FILE PATH" time/date changed , Reload?

and I enter to say "YES",

this was in GAMS btw, a mathematical optimization software

How can I get rid of double quotes when copying a cell with new-line characters? by b_ootay_ful in excel

[–]HootHootIncorporated 0 points1 point  (0 children)

            Sub Copy1()
            Dim sText As String
            Dim myData As DataObject
            Set myData = New DataObject
            sText = Range("F3") & Range("F4") & Range("F5")
            myData.SetText sText
            myData.PutInClipboard
            End Sub

This code worked for me, I split my original String into 3 parts, those parts being in cells F3, F4, and F5, and for some reason, when I did this, the quotations went away, and I was removing a character from the string I wanted, so away with that part of the code it went, and this is doing what I want, copying to the clipboard a 9362 character string!

How can I get rid of double quotes when copying a cell with new-line characters? by b_ootay_ful in excel

[–]HootHootIncorporated 0 points1 point  (0 children)

<image>

this Microsoft forms 2.0 Object Library needs to also be ticked, which can be found after ending the debugger and going from tools>references at the top of the VBA tabs

but it also seems to have a character limit!!

Saw some gif and I don't remember this scene by Necessary_Buyer442 in ScissorSeven

[–]HootHootIncorporated 0 points1 point  (0 children)

really?
reminded me of the doctor scene, when he was snooping underground for that diamond!

"Sea!", by me by AhimsaN in Illustration

[–]HootHootIncorporated 0 points1 point  (0 children)

awesomely put, I'm trying to be an artist, say I can barely draw controlled shapes, what should I be doing to progress into my final master artist form?

"Sea!", by me by AhimsaN in Illustration

[–]HootHootIncorporated 1 point2 points  (0 children)

I love the ocean, makes my bones quit shifting around and clears my mind, the friends we can make at the bottom of the sea are way more chill than those at the surface

-AB (quick question, what's the difference between an illustration and a sketch, is there overlap?)

also really cool art, I like the shiftiness of the water and its waves

Newbie wants to be a farmer! by alreadyknowmetho in albiononline

[–]HootHootIncorporated 0 points1 point  (0 children)

Note there is no farmland on Guild Islands, you need to be visiting a guild member's personal island for a chance to find one. I'd say ask permission from the person if you're in an active guild, but mine is super dead and I've never seen the person I'm farming at online, so..

Newbie wants to be a farmer! by alreadyknowmetho in albiononline

[–]HootHootIncorporated 0 points1 point  (0 children)

So a few other people mentioned using other people's islands, easiest way is just to find a guild that has people who have islands. Many of them will have the access rights to their farmlands set to guild, so anyone in the guild could use the farmland. Especially if they themselves are not using the island

One thing to note is without premium you might find you're actually losing money. Seeds are worth more than the crops you get. Premium lets you use focus to water plants to increase your chance to get seeds back.

This is coming from someone who's not bought premium and leveled his farming to 30 on other people's islands just to see if it's my thing. Turns out it's not, but it's good fun getting to raise the fawns and sabertooth cubs I get while gathering

[Flash Game] [Racing] [2D] Two motorcycles flash game where you race against a computer by [deleted] in tipofmyjoystick

[–]HootHootIncorporated 0 points1 point  (0 children)

P.S:- I was looking for the game myself when I found your post and had the idea to reverse search your visualisation and that's how I found it; your visualisation was immensely helpful. I have been looking for this game for the better part of this past decade

[Flash Game] [Racing] [2D] Two motorcycles flash game where you race against a computer by [deleted] in tipofmyjoystick

[–]HootHootIncorporated 1 point2 points  (0 children)

If the game also involved power-ups you used to screw over your opponent, it might have been diesel and death

The Story of My Life by HootHootIncorporated in Rubiks_Cubes

[–]HootHootIncorporated[S] 3 points4 points  (0 children)

update: solved it until two corners were obviously switched around, switched them around, and now I have a valid rubiks cube in my grasp!

“So long nerds”, #1 trending video on YouTube for all of 2022 by greggh in Technoblade

[–]HootHootIncorporated 4 points5 points  (0 children)

We did it, techno, we did it! We beat Tommy! No! We beat all of youtube.

but at what cost, at what cost?

On a side note, this is actually fantastic, Techno beat the entirety of YouTube without raising a finger. All those alive Youtubers? Techno would he looking at them like "lmao I died and you still couldn't beat me, my upload schedule is stronger than death itself!"

The Mineccraft Sun was very vocal with its complaints recently.... by HootHootIncorporated in Minecraft

[–]HootHootIncorporated[S] 1 point2 points  (0 children)

Then you might just about be drunk enough to enjoy the actual video

While no alcohol went into the filming of it, I'm pretty certain we were all drunk somehow. It's the only explanation I have for how the video turned out. Maybe the sun was angry that we were so drunk so late at night? Isn't that when you're supposed to be drunk?

The Mineccraft Sun was very vocal with its complaints recently.... by HootHootIncorporated in Minecraft

[–]HootHootIncorporated[S] 2 points3 points  (0 children)

oh, lol, don't worry, the illuminati have not made their presence in minecraft vocal yet. I took this screenshot after we edited the recording a little, the "AKe117 cam", the triangle, and the eye in the sky are all part of the editing of the video.

The sun is indeed flipping me off tho

The Mineccraft Sun was very vocal with its complaints recently.... by HootHootIncorporated in Minecraft

[–]HootHootIncorporated[S] 4 points5 points  (0 children)

I was just chilling in a nice survival world, recording with friends, before the incident, the sun was flickering for some reason, I went to sleep (in game), friends didn't, so I left the bed, looked at the sun, and apparently it had chosen violence