Hi Guys,
I am trying to save a Excel2010 spreadsheet with some buttons and macros into 2003 format so that other colleagues can use it. However, the macros will not work when I save the file as .xls and open it using windows 2003. Do you guys have any ideas as to why that might be? The file is too large to upload....thanks!
Regards
Jaime
The biggest issue you'll find is the maximum worksheet size of 65536 rows by 256 columns in 2003.
For example, if I'm looking for the last row of data in 2007 or later I'll use:
however, in 2003, the above would error as out of range.
Please Login or Register to view this content.
2003 version:
Please Login or Register to view this content.
However, there will be plenty more. Without seeing your workbook, it's very difficult to judge. When you say the macros will not work.....do you get an error message? If you click 'debug' does a line of code become highlighted in yellow?
Gimme a clue here....
No, it wont let me debug which is really annoying. Could I send it to you on an email? I really have no clue how to deal with this... thanks!
You may attach it here?
If the code sorts data for example it may use the Sort object which is not available in 2003.
- Please remember to mark threads Solved with Thread Tools link at top of page.
- Please use code tags when posting code: [code]Place your code here[/code]
- Please read Forum Rules
Its too large and I cant trim it down
Do any of the macros work, or will they all fail? May you post only one that does not work for review?
This may be a really daft question but.....are macros enabled on the 2003 machine?
Yes they are enabled. I will post an excel with only the essential macros and you can tell me whats going on please. Thanks
Here you go!, there were 3 more sheets "Coporates" "Financials" and "SSA" which I took off. Thanks in advance, hopefully you can give me some colour!
Thanks
The problems are mostly because the code uses ThemeColor, TintAndShade and other formatting code that did not exist with 2003.
Also, it will be quicker if you unprotect the code before posting for future.
Ah sorry - password 917251168
Is there an alternative to this? Thanks
I do not need it now.
Simply remove those lines.
So is there another way to color them in the same way?
There are not so many colours in 2003 as in 2007 and later. You may only have 56 colours in any workbook palette. I'm afraid I do not have enough time to go through each macro in your workbook and see what colours it will make everything, but I may say that you will often hear that it is better to develop a workbook in the earliest version of Excel with which it must work.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks