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