UDF Compatibility Between 2003 & 2000

Aug 17, 2006

I have an activity recording tool created in Excel 2003 which works perfectly (ish)
However when some of my colleagues use it on machines running Excel 2000 it falls over at the following definition

Dim dlgFile As FileDialog

this is part of the following sub routine

Sub doCopy()
Application.ScreenUpdating = False
Call Archive
Dim dlgFile As FileDialog
Dim rv As Long
Dim sCreated As String
Dim sClosed As String
Dim wsThis As Worksheet
Dim wbkAOM As Workbook
Dim sThisCol As String
Dim aAOMCol As String
Dim strDate As String
Dim wsCore As Worksheet
Dim wsDiverted As Worksheet
Dim iRow As Integer
Set wsThis = Application. ActiveWorkbook.ActiveSheet
Set dlgFile = Application.FileDialog(msoFileDialogFilePicker)
dlgFile.Title = "Select AOM Sheet"
dlgFile.InitialFileName = "*.xls"
rv = dlgFile.Show.......................

View 5 Replies


ADVERTISEMENT

2000/2003 Formula Compatibility: The Formulas Fields Do Not Populate Data Just #N/A

Apr 24, 2007

When I open an excel 2000 spreadsheet in 2003, the formulas fields do not populate data just #N/A. I can see data just fine in Excel 2003 viewer.

View 5 Replies View Related

Compatibility Between 2003 & 2007

Dec 29, 2009

I would like to send a .xls file created in Excel 2007 to a user who will work with this file on a PC that runs Excel 2003. Will they be able to open and use a file created in a newer version of Excel?

View 5 Replies View Related

Compatibility - 2007 Vs 2003

Nov 30, 2006

I want to install the new Office 2007 onto my computer.

Will my existing spreadhseets be work with the new version?

But most importantly....If I make a spreadhseet with VBA code and send to to a user with the Office 2003 version - will it still run OK?

View 5 Replies View Related

#NAME (2000 OK 2003 NO)

Nov 23, 2006

Excel 2000 spreadsheet everything is fine.

When I open the same file in excel 2003 #NAME? Error appears.

I check Accept Labels in Formulas and it helped in some places but not everywhere.

I still have lots of NAME errors in a relatively simple spreadsheet.

I Excel 2000 everything works fine.

View 9 Replies View Related

Macro Works In 97 & 2000 But Not 2003

Mar 15, 2007

I convert text file into Excel. Then what I want is to look in column C for cell value “UNT:” (it is chopped word account: ) and copy value what is in the same row next column D into column K.

Then in column K copy down the value until next not empty cell.

My problem is that it works on Excel 97 and 200 but 2003 doesn’t work.

View 9 Replies View Related

Macro In 2003 Is Not Working In 2000

Apr 25, 2008

I have constructed a macro, (with lots of help from the fine people on this site), and have distributed it to several people in the company. The macro was written in Excel 2003, and runs perfectly on all the machines running Excel 2003, but persons using Excel 2000 are getting a runtime error, variable not defined.

Is there a trick to getting a macro to run in both versions of Excel?

View 9 Replies View Related

Macro Run Faster In 2000 Than 2003

Feb 18, 2008

I have a macro which is able to run very fast in Excel 2000. Almost 5s. When i run it in Excel 2003, it takes almost 4 to 5 mins to complete. Is there any patch in 2003 i need to run the macro smoothly?

View 4 Replies View Related

Find Method Version 2000 Vs 2003

Mar 20, 2007

I have a Find Method routine in a procedure that works fine in xl2000, but fails in xl2003 with error code 9, subscript out of range.

Is there a different format for the Find Method in xl2003?

'code in xl2000

Dim CourseI As Range 'Students taking BusinessI
Dim CourseII As Range 'Students taking BusinessII
Dim BothCoursesTrue As Range
Dim Student As Range

'code
'code ...

For Each Student In CourseI
Set BothCoursesTrue = CourseII.Find(Student, LookIn:=xlValue, LookAt:=xlWhole)
If Not BothCoursesTrue Is Nothing Then Student.Offset(, 3) = 3
Next Student

View 8 Replies View Related

Filter Locked Worksheet Conflict - 2000 Vrs. 2003

Feb 1, 2007

I recently launched a model that uses filtering on protected worksheets. The model was developed in Excel 2000, and everything works perfectly for the users who are also on 2000, but my Excel 2003 users get an error on opening the workbook.

The error asks for the password to unlock the sheet and is difficult to clear. Users have to hit Cancel 8 times to clear the error, at which point, the model appears to function perfectly. (There are 12 worksheets in the model, 2 with filters, all locked and password protected.)

The follwoing code is in the 'ThisWorkbook' module:

Private Sub Workbook_Open()
With Worksheets("Initiatives")
.Protect DrawingObjects:=True, contents:=True, userInterfaceOnly:=True
.EnableAutoFilter = True
.Protect contents:=True, userInterfaceOnly:=True
End With

Because the error occurs when first opening the model but not at other times, I'm thinking that there's something in the Workbook_Open procedure that is causing the error.

View 9 Replies View Related

Run A Macro On My Machine (Windows 2000 And Office 2003)

Jun 29, 2006

I'm trying to run a macro on my machine (Windows 2000 and Office 2003) and I keep getting an error on one method. Now I tried to run the same macro on a different machine (Windows XP and Office 2003) and it didn't error out.

Public strControlTitle As String
Public strControlTime As String
Public strControlUnit As String
Public intControlItem As Integer
Public intLastNameOnly As Integer
Public intDataType As Integer


Sub Main()
Dim strControlItem, strPageName, strValue, sigma, z95, z99 As String
Dim r, c, count, cmax, rmax, rt, ct, low, high, a, b As Integer
Dim lesscol As Integer
With ControlChartForm
.ComboBox1.AddItem ("Average Turn Around Time All Patients")....................

View 4 Replies View Related

2007 Compatibility

Jun 29, 2007

I have downloaded Excel 2007 as a trial on to my computer (with Excel 2003 in another directory), when I load an excel file developed in Excel 2002 (containing macros) and try an open it with Excel 2007 the message "This workbook has lost its VBA, ActiveX controls and any other programmability-related features" - no problems in Excel 2003

My operating system is XP SP2

View 9 Replies View Related

Auto Filter Compatibility

Aug 3, 2006

I have a spreadsheet created in Excel 2003. All the non-entry cells are locked. When I protected the sheet I ticked the option for the auto filter to work. The problem is when I send the spreadsheet to my user - she uses Excel 2000. The auto-filter buttons do not work for her but they do work for me. Is there anyway round this? I need to have the sheet locked (apart from the entry cells) but I also need the auto filter function. I've attached the spreadsheet I'm talking about. The protection password is set to "password"

View 2 Replies View Related

TRUNC Dates For Vlookup Compatibility

Jul 7, 2008

I have a two sets of data, from two different programs (Excel and Access), were the dates are not compatible with each other in vlookop in excel. The problem seems to be in the decimals of the datevalues, which I have been trying to solve the problem in various ways. The only thing I can get to work is to trunc the dates to get rid of flawed decimals somewhere in the end of the datevalue.

My question to you is how many decimals I should use when I trunc in order to keep the right date in the format of (yy-mm-dd hh:mm). So far, 10 have proven unsuccessful (=trunc(A2,10)), but 8 seems to work. I wonder if I can decrease that number even more and still keep the format above?

View 9 Replies View Related

Excel 2007 :: VBA Disable Compatibility Alert

Feb 27, 2014

Currently I am working on a workbook where I am using a Save As VBA to create a folder and rename the file. The following code seems to be working fine so far with Excel 2007. Is there a way to confirm that it will work with all other versions of Excel and that my DesktopFolderPath String will work on all users machines?

In addition to these concerns, I am trying to avoid any Runtime Errors and currently, the Compatability Alert is the only thing I can see that is creating one. When it displays, in the event the user is unsure what to do, as most of our field staff is, and they select "Cancel" it displays the error Run Time Error.jpg. Can the Compatibility Alert be disabled? If so where do i add it in my code.

View 3 Replies View Related

VBA Code Opens File In Compatibility Mode?

Jan 3, 2013

I have written a macro to loop through files and subfolders to open a specific file for a specific month. I extract the datasets for every excel file into a master template. The code works flawlessly when all of the files have the .xlsm extension. However, I need to open .xls file formats also. When my code opens the first .xls file, named "Staffing Plan.xls" it opens it and automatically makes it "Staffing Plan1 [Compatibility Mode]. I can't open the file in the original "Staffing Plan.xls" file format to read data from. How can I fix this?

View 3 Replies View Related

Excel 2007 :: Saving Worksheet As New XLS File Without Compatibility Checker

Apr 24, 2013

We are using Excel 2007.

I have a macro enabled spreadsheet and I need to save one sheet into a new file that is in xls format. I can do that --- is there anyway to suppress the Compatibility Checker box to make it that much easier?

The new file will not have macros as will just be a data in rows and columns so compatibility. Interesting is the compatibility checker box says there are links to the original spreadsheet, but I can't find them in the connections menu.

View 2 Replies View Related

Retain 2003 Code In 2007 And Back To 2003

Aug 29, 2008

I've created a workbook with code to email it to a reviewer then back to the originator when reviewed (along with other editing functions etc.). The problem - The originator is working in Excel 2003, the reviewer in 2007. The macros work great until the reviewer sends it back. I have not been able to figure out which FileFormat:= ???? to use when I SaveAs prior to emailing as an attachment. My Excel 2003 doesn't recognize the .xlsm file and other formats are eliminated the vba/macro coding

View 4 Replies View Related

Add Ins For 2000

Mar 30, 2005

Where do i find the numbering add ins for Excel 2000? I receive a message
every time I open a document that says: I must load them for optimal
numbering and toolbar behavior. I have looked in the add ins by going to
add remove program, selecting Microsoft office, then change, then excel.
under the add ins there is nothing that says "numbering". I have also looke
on line for a down load at the Microsoft web site.

View 14 Replies View Related

Calendar Pop Up In 2000

Oct 17, 2008

I created a calendar control pop-up in Excel 2003.

To create, I did the following:

First: I went to Insert>Object>Calendar Control.

Second: I inserted following code

View 10 Replies View Related

Opening 2003 Files From Word 2003

Jan 8, 2010

how to write a code where i can open Excel2003 file from Word2003 and delete data from Sheet1 and then close the excel2003.

All this is done from Word file.

View 9 Replies View Related

Selecting MS Word 2003 Table From 2003

Feb 13, 2010

I can select a MS Word 2003 Table from my Excel 2003 macro? I keep getting Error 438 as per attached file for the line of

View 2 Replies View Related

2000 Opening Files

Mar 12, 2007

Last monday I clicked on my quick launch icon for my time card, which is in excel. It opened up, but I got an error message saying that excel had an error, send report or don't send report. Closed everthing out and clicked on the icon again, but this time excel oppend but the file did not. I get just a blank (don't know what to call it) spreadsheet. There are no cells to enter anything in. I do get the "File, Edit, View, and so on" at the top. I can click on File than Open and browes for the file and open it that way, but I can't open any Excel file by double clicking it in explorer.

View 10 Replies View Related

Delete The .xlb File In 2000

Dec 2, 2008

I have created an AddIn with code for menu buttons. When I delete the .xlb file it is replace with one about 12 KB. After some use it starts growing. One station had it to 1 meg. Could this increasing file cause problems for the code? If so, is there a way to keep it from growing?

View 5 Replies View Related

Toolbar Menu (2000)

Jul 2, 2009

I coppied this code from: http://www.contextures.com/xlToolbar02.html. Modified it to show menus but how to add sub menus? (This is the only code I found that works on Excel 2000, so far).

View 4 Replies View Related

2000 And Operating Systems

Aug 23, 2009

If I have an application developed in Excel 2000 with Vista Operating System, does it matter what operating system (XP or later) under which it runs.

View 2 Replies View Related

Autofilter 2007 Vs 2000

Sep 7, 2009

In using Autofilter on a Date column in Excel 2007 compatibility mode (Vista) and in Excel 2000 (XP), I receive different selection criteria (see pictures attached). In Excel 2007, I can select by year, by month. In Excel 2000, I am presented with all dates available in the filtered column.

I realize I can do a custom filter in Excel 2000 with a range of dates to select only the month I wish to query but this is cumbersome for the user. Is there VBA code available that will allow the same or similar selection criteria in Excel 2000 as is available in Excel 2007?

View 4 Replies View Related

Find An Average In 2000

Jun 2, 2009

I have a total in F16 that i need to find an average of.

The range is set from f4 - f15 (12 months) and need to find the running average per month. but as we only have done 5 months of the year so far that is the only average required (F16/5).

I need this to count at the end of june (F16/6) basically not counting any zero months (jul, aug, sept etc until the end of each)

View 5 Replies View Related

VBA - Using 2007 Macros In 2000

Feb 2, 2009

I have made a couple of Macros in VBA for 2007 that resize re-font etc a graph, and another one that exports te graph as an image. I want to use these macros on a few other machines but they are running older versions of Excel and i get an error when i try and use the macros.

Would someone mind taking a look and showing me how to adapt them to work in excel 2000/2003

First macro:

Attribute VB_Name = "Module11"

Option Explicit

Sub ModifyChart()
Attribute ModifyChart.VB_ProcData.VB_Invoke_Func = "u
14"
ActiveChart.ChartArea.Width = 900
ActiveChart.ChartArea.Height = 600

ActiveChart.ChartArea.Interior.Color = RGB(233, 233, 233)
ActiveChart.PlotArea.Interior.Color = RGB(233, 233, 233)

If ActiveChart.HasLegend Then
ActiveChart.Legend.Font.Name = "Verdana"
ActiveChart.Legend.Font.Size = 16
End If..........................................

View 9 Replies View Related

2000 To 97 Conversion Issue

Apr 29, 2003

I have built a nice employee time tracking device in Excel 2000. It is pretty self explanitory ("IN" time, "OUT" time, total time, etc). What I am having problems with is the VB code that is behind the "OUT" time. In essence, once an "OUT" time is entered, the ms error message box is overwritten to ask what type of break the person took (No Lunch, 1/2 hour, 1 hour) and takes the response and implements it into the Total hours calculation. Works great in 2000, but the users are getting problems in 97. i don't have 97 and can't seem to trouble shoot it. Could some guru with 97 have a look at this and see what exactly I am missing in 97.

The code is a manipulation of Ken Getz's brilliance by Stratos. Which can be viewed at the following: http://groups.google.com/groups?hl=e....warwick.ac.uk

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved