Caching?

Tech-Archive recommends: Fix windows errors by optimizing your registry

I have a template that basically uses a macro to copy and paste from all
input files that are placed in its same folder and paste that stuff into
itself. It also extracts the dates from the end of each of the filenames.
I ran it with a lot of files there and it, basically, worked. I know that
it does not know the names of the files that will be there, in advance.

Then, I start over with a fresh template and try to run it again with many
of the files removed from the folder, and VB gives me an error message
telling me it can't find some of the removed files. Someone says it's some
sort of caching, apparently. I don't understand. Is there some way to
clear EXCEL caches? How would a fresh copy know of files that it,
presumably, has never seen?

Let me know if I need to show you the macro, which was created by somebody
else. I hope not because it seems that my question is more basic

Thanks!
Dean


.

Relevant Pages

  • RE: word error
    ... your Normal.dot template may be infected with a macro virus. ... How to remove WLL add-ins and templates in the Word and Office Startup ... Startup folder is causing the problem, ...
    (microsoft.public.office.misc)
  • Re: Autotext Parent Path
    ... > need to somehow install the template on to the users computer so that ... > will be distributing this in such a way that I would like the ... > macro warning doesnt come up? ... >> The code below will insert the name of the folder containing the ...
    (microsoft.public.word.docmanagement)
  • Re: Perform task on multiple sheets in a folder
    ... Change it to your folder and run the macro in your template file ... How do you want to name the sheets in the new workbook? ...
    (microsoft.public.excel.programming)
  • Re: VB Code .dots vs .docs
    ... a .dot linkage.... ... where a document will no longer recognize the template in the Startup folder? ... folder of the user. ... If you use the File> New dialog (or the equivalent Documents.Add in a macro) to ...
    (microsoft.public.word.vba.general)
  • Re: Autotext Parent Path
    ... need to somehow install the template on to the users computer so that ... macro warning doesnt come up? ... > The code below will insert the name of the folder containing the active ... > the text into the footer many times. ...
    (microsoft.public.word.docmanagement)