Wisconsin Takes A Stand For Fiscal Sanity

[KrazyHorse]

I am still struggling with vba. My god, the people who built this database are idiots.

[Kuciwalker]

I feel your pain

[KrazyHorse]

Is there a usable alternative to sendkeys to fill in form data? Sendkeys seems to stutter

[KrazyHorse]

Btw, I have already put in sleep commands between each call. That seemed to help slightly, but there are still problems

[Kuciwalker]

Is there a usable alternative to sendkeys to fill in form data? Sendkeys seems to stutter

*shudder*

You can't just see the form's source (I assume it's a VBA form) and set its form fields, call its event handlers directly?

e.g. if it's Form1 with TextBox1 and CommandButton1 you just say something like

Form1.TextBox1.Value = "whatever"
Form1.CommandButton1_Click

[KrazyHorse]

No, it is a web form with some kind of backend we don't have access to.

Finished. A few thousand entries with a stutter rate of 1% or so.

At least I could compare output to input programmatically to pinpoint errors.

[KrazyHorse]

It didn't help that the managers who built the input had typos either...

[Kuciwalker]

No, it is a web form with some kind of backend we don't have access to.

Finished. A few thousand entries with a stutter rate of 1% or so.

At least I could compare output to input programmatically to pinpoint errors.

Gah, sorry I didn't check back sooner. If you looked at the web page and the name of the form fields + the URL you can do something like this:

With New MSXML2.XMLHTTP
	.Open "POST", "some url", False
	.setRequestHeader "Content-Type", "application/x-www-form-urlencoded"
	.send "field1=" & field1 & "&field2=" & field2 ...
	Debug.Print .responseText
End With

[Kuciwalker]

Note that to do that you'll need to go to Tools->References and select "Microsoft XML" (pick the latest version available) in the VBA editor.

[KrazyHorse]

Okay. It is done for now, but I will use that next time.

[KrazyHorse]

Is there any good reason that vba can't easily mimic stdin without ****ing it up?

[The Mad Monk]

That doesn't solve any of the problems of using student testing to evaluate teachers.

How so?

[Wezil]

On a related topic - When do the WI layoffs begin?

I gather if they can't reduce entitlements collectively they plan to do it individually.

[Jaguar]

That post is going to be too complicated for anybody here other than me and you. Even relatively simple micro stuff is beyond most of them. A point that relies heavily on somebody not implicitly assuming the fallacy of composition will not be taken.

Hey, I occasionally read threads that Kuci links for me.

[KrazyHorse]

What is your point? Until otherwise demonstrated you are lumped with everybody else.