Chris

I have this ass-long formula that checks invoice things.  I decided to put it into a function, and just call that function.

The cell:

=determineState()

The function (or at least some of it):

Function determineState()

rowNum = ActiveCell.Row

dateSent = Cells(rowNum, 8)
datePaid = Cells(rowNum, 10)

retVal = "I: "

' Has it been paid?
If datePaid <> "" Then
retVal = retVal & "paid"
Else
retVal = retVal & "sent"
End If

determineState = retVal

End Function

And yet, the result does not refresh well.  If at all.

What the hell?

I am using Excel 2007.  I want to get an image and put it in an Image thing on a form.  I can do that fine.  What I can't seem to do is resize the image.

I'm previewing scans, so I want to resize the scan, while retaining the h/w ratio, to fit the Image thing.

How do I do this?

I have a little Excel macro that processes reports for me.  At one point, it opens up two Open File dialog boxes in succession.  The first is to the left, the second is off to the right, dunno why.

[code for opening the first file]

MsgBox("And then a step to the ri-i-i-i-i-ight!")

[code for opening the second file]

This was required.

Wait.  Does OpenOffice now support VBA code?

*tests*

*grins widely forever*

Holy crap!

I just found some Outlook VBA code that'll convert incoming email to plain text!

!!!

I just took call stats and made an .asp page to display the stats in realtime.

I also made a few macros in an Excel workbook to transform Gamelo.net games into an Excel sheet, complete with locking, clear unlocked, and checking capabilities.

(Because I'm used to a different site, which checks as you go, and allows for things like dragging the mouse to change a group of cells to a different colour.)

I want to make it so that I don't have to define names for the .asp page - rather, that it gets all uniq--

...

NO DAMMIT

I am going to go EAT FOOD and then go to BED.

*pats projects*

*runs away*