Scott Meyer's has a book out called Effective C++ which many C++ programmers consider a bible on what not to do or how to do it better in C++.
I know there is a book called Effective Visual Basic out there but haven't looked at it yet. In the meantime I'm looking for similar "gotchas" for VB...
First, what would be a good book/reference for using VC++ and for learning the libraries of C++?
I'm new to C++ and have never used VC++ before. I've tried to coordinate 3 tasks using semaphores but am having difficulty getting the synchronization correct. I am trying to work the problem from...
No need to try it on Excel '97. I can do that. I just couldn't even get it to work on Excel 2000. But, it is exactly what I wanted so if you say it works, I obviously and doing something wrong. Will give it a shot tonight.
Thanks again,
Andrea
Can I ask which Excel you are running? I'm currently using Excel 2000 but this application will be 'downgraded' to Excel 97 (so I'm careful about what I use).
It doesn't work for me. I even put the equation on my sheet and used values only on this sheet and it didn't work. You actually tried it...
I know I can't use references to other workbooks as parameters to SUMIF. It returns #VALUE errors if the workbook isn't open.
However, I read on google someone using
SUM(IF([workbook]Sheet1!A1:A10<=aValueInThisWB, [workbook]Sheet1!D1:D10,0))
I could not get this to work. Anyone see any...
I have a database that keeps track of comments users make on files being reviewed. When we review several files at once, things get quite confusing. Among others, there are2 fields, a "filename field" (the type of the field is chars but it is the one that is constrained to ~50...
Thanks. I should have made myself a bit clearer. Know about both of these two methods but 1) FaceID does not work and 2)problem with looking for the icon is entirely that I could not find it - but know it exists somewhere because it is used. Do you know what the file is called, Ivan?
I had to do a similar thing a while back.
I created a named range for my data. For arguments sake, let's assume my data was A1:C1. The source data for my chart pointed to this named range instead of cell references.
For data that was subsequently added to the worksheet which my chart was...
Have unique "keys" in the format of 1-111 in Excel. Want to be able to generate thru VBA the next sequential key.
Can't just add one to 1-111 because 1-111 is a string. Need to be able to get from 1-999 to 2-000 also.
Any suggestions on how to handle this most efficiently?
Andrea
Created a 'search' button. Want to put a magnifying glass as the icon on the button. Currently have binoculars but they are too large and making them smaller makes it hard to determine what they are. Does anyone know which font and letter/symbol make the magnifying glass?
Running XP and windows...
I am very new to access and am modifying some inherited VBA code in Access 2000.
A button on the Access DB toolbar allows a user to send e-mail. The e-mail contains an attachment but I cannot see how the attachment is generated. The line
doCmd.sendObject acReport, "theAttachment"...
I am new to MS access and have inherited an application for support. The tool was developed in Access 97. We are distributing it now to machines running Access 2000 (SR1). The application worked great for the most part in 97 (running NT) and was actually tested on Access 2002/XP in preparation...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.