i installed office 2007 beta version on my computer (for testing)
together with the already existing office 2003.
now the default program of my excel files is excel
2007 beta version (not excel 2003).
can i change this behavior so that when i open an excel file the
default program would be excel 2003 instead of excel 2007
and whenever i want to open a file using excel 2007 i do
so by right clicking the file & choosing excel 2007 from the
open with list.
With the kind help of this forum, I put together a nice business tool that has a fair amount of automation via macro buttons, etc. It works great in XL 2007 but some users are having issues in 2003. I appreciate this is quite general but are there significant conflicts / differences with coding in these two different versions?
I need to find out which version of excel i am using in macro.I mean whether it is 2003 or 2007.Because i need to put 2 diff codes according to the version of excel.Can any one please provide me the macro code to findout the version of Excel.
As per title, I have both Excel 2003 & 2007 installed - I need to set 2003 as the default for opening xls files when double-clicking but can't seem to override 2007 which wants to hog all the action. I've been through the File Types menu and selected the 2003 version of Excel as the default, but it doesn't make the slightest difference.
The following simple formula was written in Excel version 97. when I try to use it on a newer version (03) it does not seem to recognise it as a formula? =IF(F66="yes",1,IF(F66="N/A",1,0))
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
The new table feature of Excel 2007 is IMO the best improvement over the 2003 version.
I have 3 questions about references to these tables:
1) When you reference to a cell in a table on the same row, you get the reference "#This Row". Why isn't there a "#This Column" reference?
2) Normally when you want to "fix" a reference to a cell you use the $ sign by hitting F4 (i.e. A1 -> $A$1). How can you do this with tables (Column1 will not change to $Column1 when hitting F4)?
3) When I have = sum(Column1) above Column1 and I drag this to a cell above Column2 I get =sum(Column2). However, when I have the formula {=sum(Column1)} this doesn't work. Why?
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
I have an excel file containing 50 sheets which we use as an accreditation test. Each sheet contains one question to which there are several possible answers. These answers (for example, A, B, C and D) are option buttons and when a user selects one, that selection is recorded as their response which is then marked. After answering a question they click a NEXT button to move on and as they move on the previous sheet (question) is hidden so they only ever see the current question sheet.
This has worked well for us for a few years, but we have just noticed some odd behaviour on ONE SPECIFIC sheet. The option button the user selects on that sheet (it is actually question 13 in the sequence) is not stored after the test is completed. However on every other sheet, the selection is stored fine - just this one sheet. The properties of all objects on the rouge sheet are the same as the other sheets. I have duplicated a working sheet and tried replacing the question 13 sheet to try that, but the problem persists.
I tried deleting that Q13 sheet and running the test without it and the same problem occured but this time on the preceeding sheet (question 12) which suggests it is not the actual sheet that is causing the problem.
This is the vb code we have on each sheet
Option ExplicitDim Response As StringDim q13 As IntegerPrivate Sub cmdQ13_Click()    q13 = 0 If optq13a.Value = False And optq13b.Value = False And optq13c.Value = False And optq13d.Value = False Then Response = MsgBox("You must answer Question 13 by selecting one of the options!", 16, "More Information Needed !")        [Code] .....
So in this example there are 4 option buttons and 1 command button. It is no different to the other 49 sheets
I have excel 2007 and I came across the following difficulty:
If I create a graph (or a chart) the default size is "Letter". However, I can switch this "Letter" to "A4" which I need and then create a template. But I always have to manually choose this template for new charts. However switching this any time I create a new chart is a rather bad way to cope with. Even clicking on set as default obviously does not cause to have A4 size for new chart, it still has got size of Letter when adding a new chart.
I assume the solution could be in XLStart templates, but it probably doesnt work for charts that you add. Or at least I didnt find any clue on the internet for this problem.
1. Is it possible to have two versions of excel installed on the same PC and would this cause any issues? This would be my preffered approach as it would enable me to do the haevy number crunching in 2007, but use 2000 for the everyday spreadsheets that I would have to share with my collegues. 2. Can you make 2007 default into compatability mode so that I wouldnt accidentaly create a spreadsheet that other couldn't use.
I have upgraded to Excel 2007 and the PivotTable formats are different. I prefer the old 'drag and drop' formatting, and would like to default to that.
I can switch to the classic format by going to Pivot Table Tools ---> Options ---> Display --> Classic Pivot Table Layout, but I have to do this for each table I create. I'd like this to be the defaut choice.
I've searched the board and someone posted that if you add the Pivot Table/Chart icon to your task bar, that will open the old layout --- it opens the wizard, but the table that is created is still in the new format which does not enable drag and drop.
I have some schedules set up with multiple formulas and macros (originally setup in 2003) however when attempting to make this a 2007 file when I go to copy a sheet to create another schedule I get the message “A formula or sheet you want to move or copy contains the name “xx”, which already exists on the destination worksheet. Do you want to use this version of the name? To use the name as defined in the destination sheet, click yes. To rename the range referred to in the formula or worksheet, click no, and enter a new name in the Name Conflict dialog box.”
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?
I've been putting together an automated spreadsheet that has external data sources to SQL. I have been having some strange problems with it between versions of Excel. Unfortunately, the company's standard is 2003 but quite a lot of the company use 2007. I have been developing this report on 2007, the server that runs the automated version of the spreadsheet runs 2003 (and cannot be upgraded beyond 2003 as it is running Server 2000!).
The template opens fine on my 2007 machine and all development work has been run on my machine including the downloading of data. The VBA script runs something like
My company used to have Excel 2003. I had a PivotTable in a worksheet that accessed data in another, completely different worksheet. When we converted to Excel 2007, I saved many of my Excel files from .xls to .xlsm. My PivotTable that once accessed data from another .xls file is still trying to access that same .xls file. What I want, though, is for it to access the new .xlsm file.
I have a spreadsheet that collates a list of data from week order and puts them in a graph. I have a macro created that basically does the graph, it works fine in 2003 but not in office 2007. I get an error "Run Time Error '1004' Application-defined or object-defined error, then when I click the debug button it highlights "ActiveSheet.ChartObjects.Delete". I'm not sure if when its trying to create a new graph its attempting to delete the old one and isnt deleting it? The full code for the macro is below:
Sub updateStuff() Dim searchResult As Range 'Result of the find operation - to check if it has worked or not Application.ScreenUpdating = False If SheetExists("OTIF Chart") Then Application.DisplayAlerts = False Sheets("OTIF Chart").Delete Application.DisplayAlerts = True End If Sheets("OTIF's").Select Range("B4:N4").Select Selection.Copy Sheets("Graph").Select Range("B1").Select................................
I created a Macro in 2007 and it turns out I needed to develop it in 2003. Now none of my code works and I am trying to convert it. I would appreciate any assistance determining what needs to be corrected and how to correct it. Here iare two samples that is repeated throughout my code.
'Delete anything currently in spreadsheet Application.CutCopyMode = False Range("A2:N1048576").ClearContents Range("A2").Select ActiveWorkbook.Save
For a particular requirement I want to utilise the colours. ANd therefore I need to know, how many colours are present in the Colour Palette in both 2003 and 2007 and which colours would be same if I make the File in 2007?
I have read some information that really scares me.It seems that Excel 2.003 is still superior to Excel 2.007. The comparison table is here: http://www.add-ins.com/Excel%202003%20versus%202007.htm
It works great in xl2003, and it works properly in XL2007 until you try and change it. I changed the column F to Column D and now it gives me a #value.
I'm struggling constantly with the Excel 2007 I use, and the Excel 2003 that another group uses.
I'm dealing with large files; 200000 to 300000 rows often.
I wish there was a setting or way to automatically force excel 2007 to create a file in 2003 format.....meaning I want 260000 rows to automatically be divided up into 4 sheets limited to 65K each. 260001 rows would be put into 5 sheets, so that I could save it as an excel 2003 file.
Is there also a way to do this from access 2007 exported to excel?(I know that's an access question and probably outside the bounds of this board).
I created this code in Excel 2007 now i want to put it on my other users machines they are using Excel 2003 and i keep getting debug errors can someone help
Sub setup() ' Keyboard Shortcut: Ctrl+Shift+C 'add sheet Sheets.Add After:=Sheets(Sheets.Count) 'format headers With Range("A1") .Value = "Job Name" .Name = "Arial" End With With Range("A2") .Value = "Quote #" .Name = "Arial" End With With Range("A3") .Value = "Job #" .Name = "Arial"
