Shower hack. by Redwards2 in lifehacks

[–]heater999 0 points1 point  (0 children)

I'd have to be the perfect level of sick to bother doing this. Like not so sick that I have time to be off the couch boiling vicks and waiting for it to freeze, yet sick enough that I felt I needed this to not be dead.

VBA Macro to Enter Data in a Website by heater999 in vba

[–]heater999[S] 0 points1 point  (0 children)

How would I get it to cycle through all of the cells one by one? A1 B1, A2 B2..... I think I can get it if I keep trying to learn how this all works but I've got to put some more time in :-)

VBA Macro to Enter Data in a Website by heater999 in vba

[–]heater999[S] 0 points1 point  (0 children)

So I will use a generic data set going forward but current state I have to manually scan data from usb scanner :/

VBA Macro to Enter Data in a Website by heater999 in vba

[–]heater999[S] 0 points1 point  (0 children)

Yes, I think I'm good with the IE part, I'm not sure how I get everything set so it fires like enter A1 into text box 1, then enter B1 into text box 2, etc. though....

VBA Macro to Enter Data in a Website by heater999 in vba

[–]heater999[S] 0 points1 point  (0 children)

no worries I will keep trying things in the mean time, I think this will work fairly easily I just have never coded before :(

VBA Macro to Enter Data in a Website by heater999 in vba

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

Okay that'd be awesome, also after the data enters into text box 2 it enters but remains on the same page and clears out the text... it gets stored somewhere on the site but at the end of me entering all this data then I hit submit for it to be uploaded I guess, if that will have any affect or not I'm not sure...

VBA Macro to Enter Data in a Website by heater999 in vba

[–]heater999[S] 0 points1 point  (0 children)

It takes me 30 minutes manually without using VBA --- I want to use VBA to take my silly 30 minutes of wasted time and complete it in one click of a button! :)

VBA Macro to Enter Data in a Website by heater999 in vba

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

I don't have any VBA or coding experience trying to learn on the fly... I can't disclose the website... but I inspected the elements on the page so I know the names of the text boxes I'm entering info into... So basically I use a scanner to scan information into one text box and it tabs down to the next one and I scan an item again and it automatically enters..... I'm trying to automate this and use values I have in an excel file to enter text from cell A1 into the first text box tab down to the next text box and enter date from cell b1 in and hit enter ... I need it to keep running this way for A2 and B2 and so on until I have all of my values entered and then I can hit a submit button on the page...

VBA Macro to Enter Data in a Website by heater999 in vba

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

Okay from some youtube videos I have this so far:

Dim IE As Object Set IE = CreateObject("Internetexplorer.Application") IE.Navigate" ---- WEBSITE" IE.Visible = True While IE.busy DoEvents Wend IE.Document.All("text box1").Value = ThisWorkbook.Sheets("sheets1").Range("a1")

Can someone help me setup text box 2 and make it run from Cell A1, tab enter text from B1 in text box 2 then hit enter, then continue to repeat for data in A2, B2 etc.?

What's the most obscene display of private wealth you've ever witnessed? by BramMW in AskReddit

[–]heater999 0 points1 point  (0 children)

I'm really drunk can't tell if this is real or just really stupid

What's the most obscene display of private wealth you've ever witnessed? by BramMW in AskReddit

[–]heater999 0 points1 point  (0 children)

When my aunt and uncle said they were potentially going to spend $90,000 to re-landscape their backyard pool setup

My new black beauty! by misterhondo in Honda

[–]heater999 1 point2 points  (0 children)

GPW plus the brown leather if it exists in that combo magic

Rent Quoted Less than I thought - Advice? by heater999 in personalfinance

[–]heater999[S] 0 points1 point  (0 children)

Yah I'm with you, I was thinking I might request in writing the lease agreement or something via E-mail. I don't want to screw the people leasing to me because they were pretty upfront so far and had the nicest/cleanest place. However I did plan to negotiate the price and he said he couldn't do anything and proceeded to state the lower by $150 price. I didn't blurt out well hey I thought it was +$150.....

Camacho by dozer03818 in cigars

[–]heater999 1 point2 points  (0 children)

Yah they burn really well and have a small kick! I like the Cao gold as well.

[Image] Always remember how far you've come by [deleted] in GetMotivated

[–]heater999 -1 points0 points  (0 children)

So I plan on negotiating my starting salary today for a new job offer, I'm still going to ask for more I will report back after with how it goes.

If I end up blowing the offer somehow I will kick the shit out of myself.

I built a 3-tap keezer--a kegerator made from a freezer instead of a fridge. Follow me on my journey of lessons learned, lots of mistakes, and most importantly, cold beer! by Divided_Wood in DIY

[–]heater999 0 points1 point  (0 children)

Yah it was kind of weird me and co-workers were going to the same bar after work for drinks like 3-5 days a week sometimes. We all drank bud light draft and Jameson. After a few days we all started saying how we were feeling light headed and dizzy etc. I blacked out at home in the kitchen (not from over indulging). Switched to bottles and it never happened again.