I am trying to create an Excel function in VBA that is similar to the SumIf() function. The difference is that it evaluates two columns.
Here is an example of the SumIf() Function:
SumI...
Hello,
I am using Excel 2000 on Windows 98 working with an existing spreadsheet trying to modify it for better use among teachers. I have the existing file here for you to download: http:/...
Hi experts,
I am looking for a source formatter which helps me to format my VBA macros.
This tool should meet the following requirements
* no more expensive than 25 USD/EUR
* it sh...
Hi gals and guys,
So far, I used to update the file dates with the tool touch.exe but I just realized that the creation date is not updated with this tool. You can check that using the Prop...
Hi Everyone,
I am trying to insert picture logo.gif into Powerpoint master slide by means of programming using VBA.
I have no problem inserting picture into every Slides , but not master...
The following macro is not working correctly. I can't figure out for the life of me what is wrong with the code. I get a run-time error on "If c.Value = m Then" line with a c.Value error of ...
I need a formula/s that will allow me to take: Start Date, End Date, Payment Amount, then compute from a drop down menu (Weekly, Bi-Weekly, Monthly, Quarterly, or Semi-Annual payments), the Nu...
History:
Excel file created in Excel XP.
Opened in 97 and added my own ActiveX Control. This was done on the workstation that has Visual Basic 6 (sp5) installed and where the control was ...
How to open existing word document (which is NOT read-only) as read-only from command line or equivalent?
I'd like to open some files so that Word would not mark it as being edited, and th...
How can I completely disable the Office Clipboard in Word 2000/XP?
Or, if it is not possible to disable it for just Word, can I disable it in all Office apps?
I suspect this is a really ...
I have a macro that sends selected data from a spreadsheet to a series of email addresses. That works fine but the emails that are sent out always have the same subject and the attached file h...
I know in Word you can use SaveAs to invoke SaveAs dialog if the current file is a new document. However, it doesn't work in PowerPoint.
Can someone tell me how to invoke SaveAs dialog in P...
I have a powerpoint presentation with a menu and buttons on several slides. Now I want people only to be able to use the menu or de buttons/ hyperlinks but not by clicking the mouse or other c...
I have a movie file I would like to insert into a Power Point Presentation, but Power Point gives me the error "cannot display this type of sound or movie." I looked in the help file and it s...
I have a spreadsheet with 14,000 rows. For one of the columns I need to hit the ctrl down arrow to get to the last entry, then do autofill to the next entry and then start the process over. ...
Does anyone know VAT formula or can tell me where i can find Access/VBA library for VAT formula. In Europe and Canada, they use VATand can be up to 10 VATs.
Let say, given: qty=1, Price=$100...
I'm set at 16 bit high color. It just dawned on me that no red is appearing on my screen. I used to get it (like MSNBC'S PAGE)and I used to be able to underline items in Word 97. But now wh...
With the following information: Original Note Date, Current Principle Balance, Interest Rate, Payment Amount,Term of Loan and Next due date: I need a formula that would calculate the Balloon ...
I know it exists, I've seen it once. How do you get at the Pinbal Easter egg in Word 97?
FYI Excel 97 When first opened Goto (Ctrl G) x97:l97[Enter][Tab] then [Ctrl][Shift] and double click ...
Problem, When I now open any existing Excel file, the following occurs eg I click on a short cut on my desktop to a file called Quote.xls as example and Excel opens 2 files at once the file I ...
I'm already MOUS certified on Excel 97 and I'm trying to find simulated tests for the Access 97 exam.
Will appreciate anyone giving tips/help on where to find them (Self Test Software does no...
Does anyone know how I can determine the type of an object in PowerPoint 2000 ?
I need to know if a selected object is text, a shape (for example rectangle), a group or a graph...
I`ve just starting writing my first database which includes VBA, using Excel `97 on Windows `95. I`m doing Ok with the porgramming - managing to get by anyway. My problem is that whenever I sa...
Greetings Experts,
I have a spreadsheet used to track chemical usage. Each day the levels for 8 tanks are entered into a column.
Row 1 at column C, starts the dates. Since Excel is onl...
I have some footnotes that I want to repeat. How can I do this?
