1. O

    sumproduct to find a maximum value ?

    I want the max value for red - suitable for excel 2000,thanks. <colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody> red 15 blue 17 red 16 red 14 blue 12 blue 13 red 15 red 14 red 13 red 12...
  2. J

    Access 2000 to Access 2007/2010

    Hello, I am trying to import a 2000 DB into a 2007/2010 DB. I got an error saying "Cannot open data base. It may not be a database that your application recognizes, or the file may be corrupt." I tried to repair both databases. Does anyone know how to convert a 2000 to a 2007/2010 data...
  3. F

    how to insert a date when a button is clicked

    Hi, I'm trying to create a simple spreadsheet in Excel 2000 to record routine daily checks at work. I want to insert a button from the forms menu and when I click the button I want it to insert the date it was clicked into the next cell. I'm pretty much a complete novice with excel and have...
  4. D

    Automatic Synchronization of Replicas

    Hi there, I'm currently attempting to automate the use of MS Access 2000's replication manager, but I don't have much knowledge in VBA. I am using Access 2010, but the two files I'm working with are saved as .mdb files (Access 2000). The first file is the data master (Example path is...
  5. E

    Printing to PDF

    Hi all, I was wondering if anyone can help me out with an issue I have. I have a report with some graphs on it and have been printing it to PDF to send out to the management team. I use Adobe Acrobat 9 Pro for this. I was using Microsoft Excel 2000 until November and everything was going...
  6. T

    What to use instead of FileDialog in 2000?

    I have a model that I run off of Excel 2003; however, I have about 25% of the users with 2000. I used the following code that works in 2003, but didn't realize the FileDialog doesn't work in Excel 2000 (get the variable not defined error). Are there any quick ways to fix this code so it will...
  7. J

    1004 problem with ActiveWorkbook.PivotCaches.Add

    I am trying to build a macro to be placed in a blank spreadsheet for use as a template. My development platform is Excel 2003 on Windows XP SP2. The script was initially recorded as a macro against a single data file with absolute range references and worked both on my develpment platform and on...
  8. R

    VBA code to import data from access to excel 2000

    I'm working on a Bill of Material creation automation project that requires some expertise in VBA, and I have none. The objective is to run a macro from an excel spreadsheet called "PGE BOM", to do the following: 1) Go to the folder "C:\Documents and Settings\Desktop\Auto Project" 2) Find all...
  9. PA HS Teacher

    Opening PW Protected File, Strange Behavior

    I've created an Excel/VBA application where I keep the code in one .xls/.xla file and the Data in a separate .xls file with no code. I like to keep the Data File Password Protected. I need to open the Data File many times, and without being prompted to manually enter the password each time the...
  10. J

    MSAccess reports into Excel - Version issue?

    We have an MSAccess reporting system with preset queuries and macros that dump reports and format them into Excel. I have a user who is claiming that the report when processing into Excel 2000, takes about 20 minutes in total on his machine. However, when I run the same report on my machine...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back