Re: Bypassing startup macros

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Sion Smith (SionSmith_at_discussions.microsoft.com)
Date: 08/26/04 

Date: Thu, 26 Aug 2004 03:47:02 -0700

Paul,

no the exception still occurs,

Is there a command line I can use to open it up without using the macros?

Sion

"Paul B" wrote:

> Sion, why not just disable macros when you open the workbook? To disable
> start up macros hold the shift key when you open the workbook.
>
> --
> Paul B
> Always backup your data before trying something new
> Please post any response to the newsgroups so others can benefit from it
> Feedback on answers is always appreciated!
> Using Excel 2000 & 2003
> ** remove news from my email address to reply by email **
> "Sion Smith" <SionSmith@discussions.microsoft.com> wrote in message
> news:A6F11AB9-1891-473A-8352-0B0E29B92353@microsoft.com...
> > Hi there,
> >
> > I've created an Excel sheet with lots of VBA code behind it. Unfortunately
> > Excel is now throwing an illegal exception preventing me from opening the
> > file - apparently it's something to do with the requirement for Office 97
> SR2
> > patch. I can't resolve this issue as the group IT function can't (or
> won't)
> > apply the patch!
> >
> > How can I retrieve the VBA modules so that I don't have to recreate the
> code
> > within them when I apply them to the previous backup versions I have of
> the
> > file(it could take up to a week to recreate it if I can't retrieve it).
> I'm
> > thinking along the lines of shortcut keys available in Access to bypass
> the
> > startup macro etc....
> >
> > Thanks in advance
> >
> > Sion Smith
>
>
>

Relevant Pages

  • Re: HLA and embedded controllers
    ... it has to test the return code in order to pass that exception back ... routines that wind up getting called in the middle of the call sequence ... same way with my design. ... which is stronger than MASM's recusive macros. ...
    (alt.lang.asm)
  • Re: Go ahead. Stop programming. This ensures you from any mistakes.
    ... rolled back when a constructor throws an exception. ... IDisposable is *not* a destructor. ... Macros are code generators. ... static void PrintMe ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Bypassing startup macros
    ... Sion, why not just disable macros when you open the workbook? ... start up macros hold the shift key when you open the workbook. ...
    (microsoft.public.excel.programming)
  • Re: evc4 compiler/linker producing corrupt executables
    ... Paul T. ... I have also built an "empty" program ... 0xc00000005 is a data abort exception. ... The corrupt executables are about 28kb, ...
    (microsoft.public.windowsce.embedded)
  • Re: exception handling in cobol /bs2000
    ... would be a way to go (before the ISO 2002 COBOL "exception handling" is ... >:>> for user written exection routines to handle any system interrupts. ... > You want macros? ...
    (comp.lang.cobol)