Click here to Skip to main content
15,397,084 members

Welcome to the Lounge

   

For discussing anything related to a software developer's life but is not for programming questions. Got a programming question?

The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.

 
GeneralRe: The joys of Excel Pin
Dan Neely23-Nov-20 4:10
MemberDan Neely23-Nov-20 4:10 
GeneralRe: The joys of Excel Pin
OriginalGriff23-Nov-20 4:21
mveOriginalGriff23-Nov-20 4:21 
GeneralRe: The joys of Excel Pin
Dan Neely23-Nov-20 4:48
MemberDan Neely23-Nov-20 4:48 
GeneralRe: The joys of Excel Pin
Nelek23-Nov-20 4:45
protectorNelek23-Nov-20 4:45 
GeneralRe: The joys of Excel Pin
Dan Neely23-Nov-20 4:51
MemberDan Neely23-Nov-20 4:51 
GeneralRe: The joys of Excel Pin
Nelek23-Nov-20 7:15
protectorNelek23-Nov-20 7:15 
GeneralRe: The joys of Excel Pin
g_p_l23-Nov-20 4:22
Memberg_p_l23-Nov-20 4:22 
GeneralRe: The joys of Excel Pin
Dan Neely23-Nov-20 5:18
MemberDan Neely23-Nov-20 5:18 
It's been long enough since the last time I had to do anything with VBA that I can't get it to run, no.

There's nothing in that code snippet to actually declare a macro for excel to run; and when I slapped a `Sub Macro1() ... End Sub` around all the code before the functions it promptly barfs because something on the `WScript` line is null.

Edit: In any event, I'm 99% sure I fixed the copy/pasto that caused the missing data from the sql queries, and the bug/not finished in the final report generation code that still created sets of columns for all possible X instead of the inadvertently truncated list of Xes actually being sent to the database; and will let Excel whir my fans for an hour over lunch in a bit doublechecking that I actually did fix it all.
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, weighing all things in the balance of reason?
Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful?
--Zachris Topelius

Training a telescope on one’s own belly button will only reveal lint. You like that? You go right on staring at it. I prefer looking at galaxies.
-- Sarah Hoyt


modified 23-Nov-20 11:31am.

GeneralRe: The joys of Excel Pin
Southmountain23-Nov-20 7:38
MemberSouthmountain23-Nov-20 7:38 
GeneralRe: The joys of Excel Pin
kmoorevs23-Nov-20 5:44
Memberkmoorevs23-Nov-20 5:44 
GeneralRe: The joys of Excel Pin
Slacker00723-Nov-20 5:51
professionalSlacker00723-Nov-20 5:51 
GeneralRe: The joys of Excel Pin
Dan Neely23-Nov-20 6:58
MemberDan Neely23-Nov-20 6:58 
GeneralRe: The joys of Excel Pin
Peter Adam23-Nov-20 6:37
professionalPeter Adam23-Nov-20 6:37 
GeneralRe: The joys of Excel Pin
Sander Rossel23-Nov-20 21:17
professionalSander Rossel23-Nov-20 21:17 
GeneralRe: The joys of Excel Pin
Dan Neely24-Nov-20 2:33
MemberDan Neely24-Nov-20 2:33 
GeneralWhat tools and services do you now consider part of your daily workflow? Pin
Chris Maunder23-Nov-20 3:31
cofounderChris Maunder23-Nov-20 3:31 
GeneralRe: What tools and services do you now consider part of your daily workflow? Pin
Jacquers23-Nov-20 3:44
MemberJacquers23-Nov-20 3:44 
GeneralRe: What tools and services do you now consider part of your daily workflow? Pin
Sandeep Mewara23-Nov-20 3:59
mveSandeep Mewara23-Nov-20 3:59 
GeneralRe: What tools and services do you now consider part of your daily workflow? Pin
PIEBALDconsult23-Nov-20 4:16
professionalPIEBALDconsult23-Nov-20 4:16 
GeneralRe: What tools and services do you now consider part of your daily workflow? Pin
OriginalGriff23-Nov-20 4:33
mveOriginalGriff23-Nov-20 4:33 
GeneralRe: What tools and services do you now consider part of your daily workflow? Pin
Nelek23-Nov-20 4:39
protectorNelek23-Nov-20 4:39 
GeneralRe: What tools and services do you now consider part of your daily workflow? Pin
Maximilien23-Nov-20 5:11
MemberMaximilien23-Nov-20 5:11 
GeneralRe: What tools and services do you now consider part of your daily workflow? Pin
Slacker00723-Nov-20 5:47
professionalSlacker00723-Nov-20 5:47 
GeneralRe: What tools and services do you now consider part of your daily workflow? Pin
Arthur V. Ratz23-Nov-20 6:16
professionalArthur V. Ratz23-Nov-20 6:16 
GeneralRe: What tools and services do you now consider part of your daily workflow? Pin
Gary R. Wheeler23-Nov-20 6:20
MemberGary R. Wheeler23-Nov-20 6:20 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Straw Poll

Do you expect users to read the instructions when using your apps?
  Results   290 votes