Macro recently quit working

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

I have a macro which Has been in use for several months. Recently it failed
so I started up the editor and step through the program manually. it worked
like it always did. Tried running in auto the same problem occured. I then
added a breakpoint. It stopped at breakpoint and I hit F5 again it completed
without a hitch. I added some do loops with a Beep and I am hearing the Beeps
before some previous steps are finished. The command before the loop is "fn =
Application.GetOpenFilename("Text Files (*.txt),*.txt", 1, "Select One Or
More Stat files To Combine/process", , True)"
.

Relevant Pages

  • Re: Macro recently quit working
    ... In what way is it failing: does it raise an error or just not do what you ... It stopped at breakpoint and I hit F5 again it ... I added some do loops with a Beep and I am hearing the ...
    (microsoft.public.excel.programming)
  • Re: Macro recently quit working
    ... so I started up the editor and step through the program manually. ... It stopped at breakpoint and I hit F5 again it ... I added some do loops with a Beep and I am hearing the ...
    (microsoft.public.excel.programming)
  • RE: Macro recently quit working
    ... Dim intTemp As Integer ... It stopped at breakpoint and I hit F5 again it completed ... I added some do loops with a Beep and I am hearing the Beeps ...
    (microsoft.public.excel.programming)
  • Re: Macro recently quit working
    ... When I put breakpoint at the if statement and continued hitting F8 it worked ... Beep ' Sound a tone. ... Sub CombineMultFiles() ... Or More Stat files To Combine/process",, True) ...
    (microsoft.public.excel.programming)
  • RE: Macro recently quit working
    ... failed just like mine did in auto after the 2nd open. ... Dim fn As Variant, f As Integer ... added a breakpoint. ... I added some do loops with a Beep and I am hearing the Beeps ...
    (microsoft.public.excel.programming)