Search results for query: *

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...

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 &quot;filename field&quot; (the type of the field is chars but it is the one that is constrained to ~50...

I need to find the address of a member function without making the function or the address identifier static. Is this possible?

Have unique &quot;keys&quot; 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, &quot;theAttachment&quot...

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...

(running office xp) I am writing an Excel application which needs write data to certain places in a Word document. I have created bookmarks in the Word document and from Excel, I open the file, update the bookmarks, save the file and close it. I would like to be able to do this without...

I'm running Excel 2002. I have a string that is the name of a form in my project. I want to be able to show this form. How can I do this? I tried using CallByName but cannot get it to work. (I am essentially creating a call stack. Hmm...do I have access to this?) Any ideas?

I have the following Word document: ClientFName ClientLName ClientAddr ClientID Dear ClientFName, Regarding account ClientID blah blah blah at ClientAddr blah blah blah....ClientFName ClientLName ... I will have several copies of the above letter, each in it's own folder. I will have a DB in...

I've had this working but never perfectly. On occasion for some reason I have not been able to determine, it fails (I mean the chart series gives me a 1004 error) I have a&quot;table&quot; (called LI) and an embedded chart (PH) on Sheets(&quot;QC&quot;). Sheets(&quot;Data&quot;) contains a row...

I've had this working but never perfectly. On occasion for some reason I have not been able to determine, it fails (I mean the chart series gives me a 1004 error) I have a&quot;table&quot; (called LI) and an embedded chart (PH) on Sheets(&quot;QC&quot;). Sheets(&quot;Data&quot;) contains a row...

I'm trying to redefine the 3 series of an embedded chart. At first, I did it without the use of a chart class. It worked most of the time time, but not always. So, thought I was missing something and tried to do it with a chart class. Created a class module, named it PHChartClass. Entered the...

Here's the problem: I have a workbook with two hidden sheets named SUB and COMP. SUB and COMP work together. Through button in the workbook, SUB and COMP can be copied and renamed to SUBn and COMPn. Each SUBn sheet can have many COMPn sheets but each COMPn sheet &quot;belongs&quot; to only one...

BookTitle is a variant input parameter to the routine that contains this line. This always fails on .FIND. What am I doing wrong? Using Excel '97 Dim Titles As Range with Sheets(&quot;List&quot;) Set Titles = .Range(.Range(&quot;Titles&quot;).Address...

Hi All, Can anyone see what is wrong with this code? Series PT1 and PT2 update fine all the time but BAC always fails? No errors are given, it just pops out of this function. No error handlers on. Verified that the named ranges are pointing to the correct places. I'm at a loss. Thanks in...

Wonderful Excel again! Giving all the details hoping it will give someone a clue as to what happened, because I sure can't figure it out! Have a workbook called Health containing lots of VBA. (the WB has about 4 charts and sheets and empty it is about 4Mb). Worked in this workbook last on...

Can anyone give me any advice on how to write custom help files? I know there is a way to do it but don't know where to start. Andrea