2000

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

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

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

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

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

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

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

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

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

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