Re: Reinstall EXCEL

Well, it's a little late now, although I am still asking if I could use
system restore to undo the reinstall and, if so, if I should bother. The
reinstall seems fine, although it did not fix the problem below

The details, possible sketchy, are in a thread called "caching" started on
November 4 or 5, as I recall, by me. I would so welcome your help, as no one
seems to have any idea why it is happening and it makes my EXCEL
installation suspect. To review briefly, someone created a macro for me in
an output template, that was to basically copy and paste some data from all
input files - the input files were to be all those that would be found in
the same folder as the output template - the macro would search for them.
Some of the input files proved to be empty or not have data where they
should have it and that crashed the macro, as expected. However, when I
deleted or renamed those bad files, the next time I would run the macro in
the output file, it would crash, saying that it could not find the filename
I had just deleted, or re-named. Since, I always got a fresh copy of the
output file, this kind of "memory" seems unfathomable to me. On other
computers, this is not happening.

Any ideas?

Thanks!
Dean


"Peter T" <peter_t@discussions> wrote in message
news:OLw1F%23cAHHA.3620@xxxxxxxxxxxxxxxxxxxxxxx
Before rushing into a re-install why not describe in more details what you
mean by

wherein EXCEL macros are looking for old
files that don't exist any more.

There just might be another explanation for your problem which wouldn't
get
fixed by re-installing Excel.

Regards,
Peter T

"Dean" <whooshbopbang4@xxxxxxxxxxxx> wrote in message
news:1-WdnTAglOAqHdPYnZ2dnUVZ_q-dnZ2d@xxxxxxxxxxxxxxx
I have a thread called caching and no one seems to have an answer for me.
Someone else is using the same release of EXCEL with the same files and
is
having none of these problems, wherein EXCEL macros are looking for old
files that don't exist any more. I am starting to come to the conclusion
that the kind of stuff that is happening to me can only be caused by
EXCEL
being corrupted. Does anyone have any directions on reinstalling EXCEL,
hopefully safely?

Thanks!
Dean






.

Relevant Pages

  • Re: Reinstall EXCEL
    ... I looked at your other post about 'caching' but it didn't make any sense to ... Post the macro, ... system restore to undo the reinstall and, if so, if I should bother. ... the same folder as the output template - the macro would search for them. ...
    (microsoft.public.excel.programming)
  • Re: Automation add-in stopped working, please help.
    ... Does the code exist in Excel, ... I have written an automation add-in some time ago that merely adds a ... macro 'sqr' cannot be found". ... to reinstall the entire system. ...
    (microsoft.public.dotnet.framework.interop)
  • Re: VBA: For Count, when count changes from cell to cell
    ... with Excel 2000. ... reporting Macro being unavailable. ... Sub CalculateI3() ... means that you can refer to it in a cell just like a built-in Excel function. ...
    (microsoft.public.excel.misc)
  • RE: Sorting macro needed on a protected sheet
    ... they all have Excel 2003, before reposting this thread as a new discussion to ... you will still be prompted to enter a password when running your macro even ... closing the password dialog box performed the sort macro anyway without ... Autofiltering can be restored without having to close & ...
    (microsoft.public.excel.programming)
  • Re: Exporting Hierarchy to Excel (Jack`s Macro)
    ... Now an empty Excel ... Sub dwn ... How exactly did you copy Jack's code into the VB editor? ... contains Jack's macro? ...
    (microsoft.public.project)
Loading