LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 38
Default Excel 97 not running macro that runs fine in 2000

I updated a workbook that is becoming widely distributed. I have tried to
keep it running on Office 97 computers but this latest problem has me
stumped. On computers with Office 97, Excel will not allow me to open the
module to trace the offending code. I added " If Val (Application.Version)
8 Then... " to try and trap the recently added lines. Didn't help.
The added lines that I thought were causing this a
Application.DisplayAlerts = False
..
..
and Application.DisplayAlerts = True

I don't think these are causing the problem anymore.
Is there a way to decompile an Excel file so that I might be able to again
open the file with 97 ? I really need to be able to trace the logic.
The program only fails when one macro is called. The rest of the program
works fine.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA macro runs fine, but freezes if I try to do ANYTHING else whileit runs Rruffpaw Setting up and Configuration of Excel 1 September 17th 11 01:25 PM
Excel Macro runs fine, but freezes if I try to do ANYTHING else whileit's running Rruffpaw Setting up and Configuration of Excel 0 August 3rd 11 08:31 PM
Office 2000 Excel Macro runs very slow in 2003, why? The_Other_Mike Excel Discussion (Misc queries) 1 May 10th 06 04:36 PM
Loop in my macro doesn't seem to be running; however, it compiles fine... Goobies[_3_] Excel Programming 6 February 2nd 06 01:00 AM
Runs Fine In Step Mode But Crashes Excel Otherwise ben Excel Programming 1 November 20th 04 02:29 AM


All times are GMT +1. The time now is 12:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"