| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro issues with excel 97
I have several macros in an excel 2002 workbook that will not run in excel 97.
Is there a way to determin if it will ever run or what is causing the problem? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
macro issues with excel 97
See which command chokes Excel 97, then check in the object browser or
online help for 97 what the syntax for 97 has to be. There were a bunch of major changes to VBA between 97 and 2000, and 2002 added some further changes. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "killian" wrote in message ... I have several macros in an excel 2002 workbook that will not run in excel 97. Is there a way to determin if it will ever run or what is causing the problem? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
macro issues with excel 97
There are a few new statements and methods in 2002 that were not in 97 but
generally macros should run. IF we could see the code you would have a much better chance of getting more help. "will not run" doesn't give much to go on. Gord Dibben MS Excel MVP On Thu, 28 Feb 2008 14:08:00 -0800, killian wrote: I have several macros in an excel 2002 workbook that will not run in excel 97. Is there a way to determin if it will ever run or what is causing the problem? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro Hyperlink Issues | Excel Discussion (Misc queries) | |||
| Cerfiticate Issues When User runs my Macro | Excel Discussion (Misc queries) | |||
| Data Form has macro issues | Excel Discussion (Misc queries) | |||
| Macro security issues | Excel Discussion (Misc queries) | |||
| Macro Range issues (I think) | New Users to Excel | |||
Hybrid Mode
