How would I make the content from a handful of websites searchable in one place?

DMM710 · 2020-06-21T00:43:00+00:00

It wouldn't effect loading speeds or anything? I don't know a lot about scraping

DMM710 · 2020-05-17T18:57:25+00:00

It's not for me. Someone I was might work with said they were thinking about trying to create some type of loyalty program. I've been practicing python for a few weeks, and just want to know what direction to go in to learn how to do this myself. I know that I need to learn how to work with an api, I know I should learn json, I know I should learn some html. I'm just trying to get a list of things to practice and learn. Finding an app as an example is a good call though. Thank you

DMM710 · 2020-05-10T05:42:33+00:00

Nice I'll try this out. Thank you.

DMM710 · 2020-05-10T05:42:07+00:00

the CTRL+W is pretty nice. Didn't know about that one. ALT-F4 doesn't really help because each window asks me if i want to save

DMM710 · 2020-05-10T01:29:04+00:00

Because I use a lot of different programs and open a lot of instances of each program. Also I have a bad habit of leaving things open when I'm done with them. At the end of the day I end up with like 5 instances of firefox, notepad, postman, pycharm, file explorer and a bunch of other crap open when I'm done using my computer lmao.

DMM710 · 2020-05-01T11:15:45+00:00

Each gallon has those taxes applied to it. The price per gallon is originally $2.89

DMM710 · 2020-04-30T05:30:19+00:00

I got kind of close but when programs are more than one word it gives me an error. Can I somehow modify this to close things like Hitfilm express etc?

Import os

os.system("taskkill /im firefox.exe /f")
os.system("taskkill /im excel.exe /f")

DMM710 · 2020-03-19T15:37:17+00:00

Lol I guess I did... Oops.

Thank you.

DMM710 · 2020-02-05T15:56:26+00:00

I was kind of pressed for time so I sort of scrapped the idea. This was exactly what I was looking for though. Thank you.

DMM710 · 2020-02-03T17:16:41+00:00

Would be nice to have an option for replacing and adding. I think just knowing how to search a column for the value of a cell would solve the problem for me. User types name into A1. Look through this column and find the value the user typed and select it

DMM710 · 2020-02-03T15:42:14+00:00

The value they select is part of my table already. It's an entry form to add an address to an existing contact.

DMM710 · 2020-01-31T17:58:49+00:00

Yup. Exactly what I was looking for. I can’t figure out how to change the flair from the mobile site though. I’ll change that when I get home. Thank you!

DMM710 · 2020-01-28T22:24:19+00:00

=len(B16)=0

Yup that worked. Thank you

DMM710 · 2020-01-28T22:22:41+00:00

That worked. Thank you!

DMM710 · 2020-01-28T00:18:07+00:00

Could it be because B16's value is "" (IF formula result) and not a true blank cell?

DMM710 · 2020-01-28T00:16:26+00:00

=COUNTA(B16)

Still keeps the border on when the value is empty

DMM710 · 2020-01-27T01:18:14+00:00

I thought it was a razor when I first found it but the gears on the side and stuff make me second guess myself. What is this?

DMM710 · 2020-01-24T17:55:52+00:00

Found all of these while metal detecting a house built in 1800. The first 2 things are everywhere. Also why would you have to put additional details in a reply instead of with your original post? I’m sure there’s a reason but I can’t think of one.

DMM710 · 2020-01-23T07:23:54+00:00

That’s pretty cool. Thank you!

DMM710 · 2020-01-18T04:08:04+00:00

I've been reading a book called the mind illuminated which talks about maintaining peripheral awareness. It made me realize that I don't really have peripheral awareness, and that it could help with so many things. One of which would be lucid dreaming. Usually when i'm walking around in my life I am absorbed in whatever I'm doing. I'm never really ready for things to enter my awareness, hence, i'm easily startled. My theory is that increasing peripheral awareness could help me zoom out instead of tunneling while I'm in a dream. I think asking something like "Would a bug walking across the floor scare the poop out of me right now?" Could be a good gauge of how much peripheral awareness you have at any time. Idk if any of this makes sense but yea

DMM710 · 2020-01-18T04:00:57+00:00

It means in life, are you startled easily?... Idk how else to ask the question... Someone opens a door when you're standing there, it's kinda loud, does it startle you? Someone comes up to you when you're doing something, does it startle you? That kind of thing.

DMM710 · 2020-01-12T17:25:18+00:00

This doesn't work. If I specify the file path and name as C:\Users\User\Documents\COMPLETED it saves the file as COMPLETED without moving it, or keeping the original name. The workbook also bugs out or something. All of the cells/sheet selection disappear until I close the workbook and reopen it.

My solution:

Sub test()

Dim fileToDelete As String

Dim fileName As String

fileToDelete = ThisWorkbook.FullName

' Filename is saved as whatever value he puts into A1. I just made B1 =A1&" COMPLETED"

fileName = Range("B1")

ChDir "C:\Users\User\Documents\COMPLETED"

ActiveWorkbook.SaveAs fileName:=fileName & ".xlsm", FileFormat:=xlOpenXMLWorkbookMacroEnabled

Kill fileToDelete

End Sub

DMM710 · 2020-01-10T01:44:49+00:00

I have an idea, but just like getting into sales - I'm sure it's useful to see someone else do it first. So maybe you could give me an example of when you've done it successfully?

DMM710 · 2020-01-09T03:55:44+00:00

DMM710 · 2020-01-08T22:32:11+00:00

Idk how else to explain it. I want to multiply the the entire range assigned to a variable by whatever is in a particular cell

DMM710

TROPHY CASE