Problem using Excel Xp Workbook on Excel 97
 

Hi all.
This is my first thread.
I have a big problem.
I have developed a Excel Xp Workbook using some Visual Basic function
but i try to open in on Excel 97 it gives a error message.
Excel 97 dont recognize some functios of Excel Xp.
Does anyone know any tip to resolve this problem?

Thanks

--
Message posted from http://www.ExcelForum.com

Problem using Excel Xp Workbook on Excel 97
 

You should develop and test for your oldest target version.
In other words, if users will be using Excel 97, develop using Excel 97 - or
urge them to upgrade.

If there are only minor problems, perhaps you could be specific about what
functions are causing problems. There are tricks to remain compatible with
older versions for some newer functions.

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Feiticeiro " wrote in message
...
Hi all.
This is my first thread.
I have a big problem.
I have developed a Excel Xp Workbook using some Visual Basic function,
but i try to open in on Excel 97 it gives a error message.
Excel 97 dont recognize some functios of Excel Xp.
Does anyone know any tip to resolve this problem?

Thanks.


---
Message posted from http://www.ExcelForum.com/

Problem using Excel Xp Workbook on Excel 97
 

The problem is that when i change the value of any combobox, the Offic
97 don't recognize the event "On change". It should update the value
of some fields, but don't does that.
When i open the file on Office 97 i have this error :"Compile error
Sub or function not defined".
Thanks for your time

--
Message posted from http://www.ExcelForum.com

Problem using Excel Xp Workbook on Excel 97
 

I don't have Excel 97, but someone else reading will bound to have it.

From the Visual Basic Editor, could you click the Debug menu and select
Compile VBAProject.
This should tell you errors in the code. If it doesn't do anything and the
menu is ghosted, then it's successfully compiled without error.

Can you post your ComboBox1_Change code?

eg.
Private Sub ComboBox1_Change()
....
End Sub


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Feiticeiro " wrote in message
...
The problem is that when i change the value of any combobox, the Office
97 don't recognize the event "On change". It should update the values
of some fields, but don't does that.
When i open the file on Office 97 i have this error :"Compile error:
Sub or function not defined".
Thanks for your time.


---
Message posted from http://www.ExcelForum.com/

Problem using Excel Xp Workbook on Excel 97
 

I have my function writed with some portuguese words.
That's ok for you?
I will acess to one pc that have Office 97 and then i will try t
compile the code. If there are errors in the code, i will put the
where

--
Message posted from http://www.ExcelForum.com