Differences & Incompatibilities Across Versions

Aug 26, 2008

I may be creating a small Excel-based VBA application for a client on a semi-formal basis. I personally use Windows XP with Office XP installed, but I'm concerned about the possibility of serious differences between versions of Windows and Excel that may cause my code to fail on other machines.

I don't think I need to cater to any version of Excel BEFORE that in Office XP, but I probably do need to cater for versions after it. That's Office 2003, Office 2007 and Office for Vista,

View 7 Replies


ADVERTISEMENT

VBA To Recognize Xl Versions

Jun 3, 2009

I have some codes that require different values when running under xl2003 vs. when running under xl2007.

View 11 Replies View Related

Macro For Different Versions

May 4, 2009

I have been working on this spreadsheet off and on for a while now. I have a macro that works in Excel 2007 and a different one that works in 2003 (thanks to the help of Mr.Excel.) My problem is, the people who will be using this spreadsheet all have various versions of Excel. Is there a way to script this macro to work for all versions, or do I have to have a different script for each version of Excel? The one I am currently in need of is a script for 2002. See below for the script for the 2007 version. If there isn't a way to make a "one for all" solution, some assistance on a script that would work on 2002 would be great! The section in red is the section that returns the error when people try to run it with earlier versions of Excel.

ActiveWindow.SmallScroll Down:=-9
Columns("B:G").Select
Selection.Copy
Columns("B:G").Select
Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _
xlNone, SkipBlanks:=False, Transpose:=False
Columns("L:N").Select
Application.CutCopyMode = False
Selection.Delete Shift:=xlToLeft
Range("N11").Select

View 9 Replies View Related

Installing 2 Versions (or Office On Same Pc)

Nov 23, 2008

ive got my highly expensive office enterprise 2007 disk
what is the best way of installing this so i can still use 97 and 2007. any tips?
i wont bother with outlook but i'd like to try the rest ,mind you onenote,infopath and groove are a complete mystery!

View 11 Replies View Related

Multiple Versions - One Computer

Feb 13, 2009

I'm running Excel 2007 with Windows Vista. I also have Excel 97, which I was told would not run with Vista. I've since discovered that many programs that I was told wouldn't run with Vista seem to work fine.

Is it possible to install Office 97 on the same machine with Office 2007?

View 9 Replies View Related

Store & Compress Old Workbook Versions

Mar 19, 2007

I'm looking for is ComplyXL and that costs $300 to buy. So, as a poor grad student, I'm looking for an alternative solution - either a freeware program or a hassle-free VBA code.

So here's what I need the code or program to do: When I ask excel to open a pre-existing file, I'd like it to automatically rename (& compress?) the last used version of the file & save that to a filename-specific archive somewhere (hidden?), before opening the file as requested. Alternatively, I suppose that a mirror copy of each 'just used' file could be created & saved to an archive folder whenever the used file is saved & closed.

--Note: to avoid making copies of EVERY workbook I ever use, I suppose there should also be a button in the toolbar or a file-associated setting that lets me identify which files I want this task to apply to...

Basically I'm looking to have excel automatically save versions of certain key files (like Word's 'Versioning' feature) without having to remember to 'Save As', without the versions taking up much space, and without having to store the older file versions in the same place as the most recent one.

And yes, I know that a similar problem has already been posted & solved here, but they didn't include a way to choose which files used versioning nor (if it's possible) a way to compress the archived versions to save space (maybe by adding it into a WinRAR archive somewhere?).

View 11 Replies View Related

'INDIRECT' Formula Across Excel Versions

May 22, 2009

I have made a file that works perfectly in excel 2007, but when I send it to a client it doesn't work as they have 2003.

View 12 Replies View Related

Ordered Table (compatable With .xls Versions)

Jan 4, 2010

The document shows a table on the left that puts the data from the table on the right into order by total (and if same, alphebetical by name). However the formula used to achive this is not compatable with previous versions of excel. Need alternative function that will bring the same outcome but work with pre 2007 versions (ie .xls file extention).

View 3 Replies View Related

XLS File Type Association With Two Versions

Apr 8, 2008

I am changing the file type association for .XLS to
C:Program FilesMicrosoft OfficeOffice11excel.exe

I'm using "Change" and "browse" to set it to that exact file. However it still starts version 12 (XL2007) which is dual installed with version 11 (XL2003).

I was successful in creating a shortcut that opens version 11, despite Microsoft's apparent attempt to thwart that; now I need to fix the file association. (Try to directly edit the Office links in your XP Start Menu - how the target is grayed out?

View 9 Replies View Related

Automatically Convert Older XLS Versions To Newer

May 30, 2009

I have a dir with over 150.000 files in it, especially pdf, doc and xls. Now I'm looking for a script or program that will automatically search the entire directory and look for old xls files, open them and save them in a new(er) version. I'm working with a software that needs to use these XLS files in my directory but it can't use the old xls-versions. It's an impossible job to search by hand for the old versions and put them in a new(er) version.

View 11 Replies View Related

Translating Argument Of A Function Between Versions Of Excel

Jul 2, 2013

When I attempt to send a spreadsheet using a German version of Excel, the following formula does NOT work properly.

=ZELLE("adresse",C14)

The function gets translated into =CELL("adresse", C14), and what I need is, obviously, = CELL("address",C14). The argument does not get translated.

View 1 Replies View Related

Design Spreadsheet In 2007 For Use On Earlier Versions

Jul 17, 2009

Compatibility mode, in 2007, is frustrating me like crazy. I thought it was supposed to 'limit' functionality to what was in 2003. But what it seems to be doing is letting me use features that only work in 2007and then tell me when I save that 'hey, these won't work after you save'. Ugh! I can't even pick a highlight color without getting a warning and wondering what it will look like to 2003 users!

Is there a 'theme' or anything that will truly limit the features I use to those available to 2003 users?

View 5 Replies View Related

Defining System Root On Different Versions Of Windows

Feb 22, 2007

I have to run a daily report from winxp or win2k and need to change the host files a few times for access.

I tried to use %systemroot% in the file path, but for some reason vba doesn't like it.

Here's the snippet I'm using for copying over the host file based on user choice: (the thing works if I change to the actual system root path (C: etc...)

Private Sub CommandButton1_Click()
Select Case ComboBox1
Case "- Choose -"
MsgBox ("This is not a choice")
Case "BTR"

View 9 Replies View Related

Remove X Close On UserForm. Multiple Versions

Mar 2, 2008

I've found a link on OzGrid "How to remove the (X) CloseButton from Userforms" but I can't seem to get it to work with Excel 2003. The code looks like it was written for Excel '95, '97 and 2000.

View 6 Replies View Related

2 Versions Installed But CreateObject Code Creating Old Version

Nov 27, 2009

Set xlApp = CreateObject("Excel.Application")
xlApp.Visible = False
xlApp.Application.DisplayAlerts = False
xlApp.Workbooks.Open ("somepathWebquery.xlsm")
xlApp.Application.Run "'some macro"

The only problem is, the web query will only work properly if it is in Excel 2007 (2003 will parse the table in a way that is not acceptable). However, when I tried to run the script, the stubborn Excel 2003 will show up. I even tried to uninstall the Office Compatibility Pack and the stubborn Windows will only run Excel 2003 and ask me to download the Office Compatibility Pack instead of giving me Excel 2007.

I tried to open it up using Open With...and it did not work, I even tried to regserver and unregserver and that did not work as well. Somehow Windows thought the only Excel I have is Excel 2003.

Is there anyway I could change the VB Script so that it would force Excel 2007 to open?

View 6 Replies View Related

Button Position/Coordinates On Worksheet. Discrepancy Between Versions

Apr 30, 2008

Add Multiple Buttons That Select Row Of Housing Cell. One of my Macro's places a button on a sheet using Top/Left;

Set sbut = Sheets("Listings").Shapes.AddFormControl(xlButtonControl, _
Range("J" & count).Left, Range("J" & count).Top, 50, 12)

When I try to find the row of the clicked button using the following code;

Range(ActiveSheet.Buttons(Application.Caller).TopLeftCell.Address).Activate

The code behaves differently in Excel 2002 and 2007. In 2002 it returns the row the button sits on, but 2007 returns the cell above the button. This could be because the workbook is an XLS running in Excel 2007 in compatibility mode? Is there a way to "nudge" the button down a little after it has been placed using .top/.left ? Or is the only way around this something like;

Range(ActiveSheet.Buttons(Application.Caller).TopLeftCell.Address).Activate
count = ActiveCell.Row
If Application.Version >= 12 Then
count = count + 1
End If

Is this a bug, or something that I am doing wrong ? The workbook needs to be a .xls to ensure that it works in older versions of Excel.

View 4 Replies View Related

Convert Multiple Versions Of Cell Contents To Single Version?

Feb 28, 2014

I would like to automate the conversion of multiple versions of company names contained in cells to a single company name. i.e. XYZ Inc., XYZ Co., XYZ to all cells XYZ. My data file contains numerous versions of company names. I want them to all be the same company name so sorting data is easier. I now do this manually and it is getting tedious and time consuming. Can I build a table with the different versions that then chamges the cells to a single version that I choose?

View 1 Replies View Related

Offices 2007 & 2003 At The Same Time, Choose Between The Versions When Opening A File

Jul 25, 2006

i downloaded the beta version of the office 2007 for testing. can i install this version alongside my existing office 2003 version. i want to have the 2 versions installed on my computer so that i can choose between the versions when opening a file.

View 3 Replies View Related

Value Differences

Nov 22, 2007

I have two colums with 1000 rows for column 1 and 500 for column 2 that shows gps coordinates. I want to work out the distances between the gps coordinates but want the answer only if it is less than 30 kilometres.The formulae must do the following

a1-b1 and compare the answer to a1-(b2:b1000) and give me the smalles answer in column c.

I want the closest gps coordinate to A1. Even if i do vlookup first there might still be a closer gps coordinate in row 501 than just subtracting A1-B1

View 9 Replies View Related

Dates And Differences Between

Jun 8, 2009

I have a list of 109 dates in one worksheet (call it A) and in another worksheet I have a list of other dates (call it B). I need list B to compare itself to list A and find the closest date in list A and then subtract the difference between the two.

View 4 Replies View Related

Summing Differences

Apr 13, 2007

1. I need to find the average monthly meter reading say for the whole year...this is what I have, =(C2-B2)+(D2-C2)+(E2-D2)+(F2-E2)+(G2-F2)+(H2-G2)/6 is there an easy way to do this?

2. Also need to get the total monthly reading of all the machine, the formula I have is; =C2-B2+C3-B3+C4-B4+C5-B5+C6-B6

View 4 Replies View Related

Counting Differences Between Column A And B?

Feb 27, 2014

is there an IF formula to compare values in two columns, say Column A and Column B have "Action recommended" and column B has "Actual action taken", both columns should have the same texts, in cases where there is no similarity, the formula should count the cases.

View 3 Replies View Related

Matches And Differences Between Two Lists

Sep 21, 2009

I am trying to compare matches and differences in two lists in order to pull statistics from them.

I have a production schedule I make at the start of the week (list 1) and compare that to what I actually ran at the end of the week (list 2). I would like to produce the following from these two lists;

- a list (list 3) that shows all the orders I didn't run in my original schedule
- a way of summing the number of matches (of work order #s) in the two lists (list 1 and list 2)
- and way of extracting the corresponding machine hours I did / did not run from the two lists

I have provided text boxes on the attached excel file to better explain my problem.

View 3 Replies View Related

VBA To Extract Text Differences

Jun 9, 2014

How to find the text differences between old and new values. I am looking for excel function or vba to extract all new texts added in new values.

View 2 Replies View Related

VBA To Compare And Highlight Differences

Aug 3, 2013

I have to worksheets I get from two different dbases do the output is slightly different in each. What I need is simple, (I think). Just need to get a VBA that looks from Sheet1 to Sheet2 for a doc number. If it's not on Sheet 2, simply highlight it BLUE on Sheet, AND then looks from Sheet2 to Sheet1, and if it's not on Sheet1, then highlight the entry on Sheet2 GREEN.

I.E.
SHEET1SHEET2
COL ACOL A
11111AAAAA
22222BBBBB
3333311111
AAAAA44444

View 9 Replies View Related

1 Count For Differences In Lists

Jun 28, 2009

I'm looking to compare a number of duplicate lists to an original. If a duplicate list contains 1 or more different values to the original, I want to return a value of 1. For example:

Original list
Value 1
Value 2
Value 3

Duplicate 1
Value 4
Value 2
Value 1

Count = 1

Duplicate 2
Value 1
Value 4
Value 5

Count = 1

I'd then like to sum the counts. Ideally this would all take place in the one formula, but I can split them into different cells if necessary. I can't use macros for this.

View 9 Replies View Related

List Differences Between Columns

Aug 19, 2008

Finding the differences in letters (symbols) between 2 columns eg

column 1 column 2 column 3 should show

bidu aapl aapl
ldk bidu ldk
spwr rimm spwr
rimm

View 8 Replies View Related

Compass Direction Differences

Jul 12, 2006

I'm trying to do is take the difference of two wind directions but need the actual difference not the true mathematical difference. For example:

Wind direction 350 was forecasted
Wind direction 020 was observed
The difference is 030 degrees off not 330 degrees.

How do I do a formula to state the true difference not numeric?

I was figuring these conditions:
- if the number is above 180 & below 360 just subtract 180
- if the number is below 180 & above 0 just add 180

Using w/ example:
350-180=170
020+180=200
170-200=-030 (then take ABS to get 030)

I'm a weather professional and doing tons of metrics regarding weather parameters.

View 7 Replies View Related

Compare & Show Differences

Jan 8, 2007

I have attached two excel files for easier understanding of what I am trying to explain. One is named Deviltronics which is our product list, the other is named Supplier which is our suppliers product list. The suppliers product list is updated every hour to tell me of new products, products in stock, products out of stock and discontinued products. I have cut the suppliers file down considerably to get it to fit as an attachment on this thread. They currently have about 800 products. Now for how this is currently working and the problem:

I use the suppliers file to add the products to my website manually (which is fine) by using the information on the suppliers file. I also add the product title, SKU and part number from the suppliers file onto our Deviltronics file, this allows me to keep a record. The reason I need this record is so that I can use either the SKU or part number to search the suppliers file to see if a particular product is still in stock or not. You can distinguish the supplier has a lengthy product list, although we will not be putting all of there stock on our website at least 70% of it will be on there, therefore you can see how much of a lengthy process this is if I want to check the products on a daily basis......

View 6 Replies View Related

Compare Rows For Differences

May 25, 2007

In attached spreadsheet, I have run my marco on Col A to tag which records are duplicates (macro in workbook). Now, of the records that are tagged "DUP", I would like to find which cells in Cols B, C, D, etc. have changed - ie., compare the first "DUP" record to the second "DUP" record. Some records and 2 DUPs, others have 3, 4, etc. I only want to compare the tagged "DUP" groups. Changing the cell color (or other type of tagging) the difference is acceptable.

View 5 Replies View Related







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