Bump this thread when you fix a bug

Message Bookmarked
Bookmark Removed
Not all messages are displayed: show all messages (47 of them)

was going to post some Excel VBA mysteries/irritations but really Excel VBA is one big bug in itself

nevertheless, it is the only thing I can do that nobody else in the office has ever wanted to dirty their brain by looking into

(most annoying this week: using Application.Workbooks.OpenText to open a text file, specifying all the parameters, except if the file extension is .csv Excel overrides them without telling you. So I'm going to have to write some documentation that says "look, I know the file is a .csv file, but please call it .txt or anything except .csv or it will load wrongly in a way that you may not notice until it's too late")

atoms breaking heart (a passing spacecadet), Wednesday, 16 June 2010 10:12 (twelve years ago) link

how long will it take to learn that the problem may be in the data and not the programming... 2 hours of trying to locate an extra space in a string..............urgh

bnw, Tuesday, 22 June 2010 21:19 (twelve years ago) link

strange things on the interweb:

SELECT ThePerfectWoman
FROM AllTheWomenInTheWorld
WHERE HerInterests Like Mine
AND CurrentMate Is Null
AND CurrentlyLives IN ('Yonkers', 'Bondi Beach', 'São Paulo')
GROUP BY CASE WHEN AsManyAsWillHaveMe>AsManyAsMyStaminaWillAllow
THEN AsManyAsWillHaveMe ELSE AsManyAsMyStaminaWillAllow * 2 END
HAVING Max(Libido)>=Mine

bnw, Thursday, 24 June 2010 20:29 (twelve years ago) link

lol, yonkers

original bgm, Thursday, 24 June 2010 20:58 (twelve years ago) link

You must be logged in to post. Please either login here, or if you are not registered, you may register here.