Using VBA to disable macros when opening files

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

I am using VBA to create a loop to open up a number of XL files - however I
want disable any macros that the files may contain when opening these files

Any help gratefully received

Thanks

James
.

Relevant Pages

  • Loop through fields and update nulls to zeros
    ... How would you loop through fields and update null values to zero's in vba? ... If it was only one field, I would run a query or write an SQL statement. ... Prev by Date: ...
    (microsoft.public.access.modulesdaovba)
  • Re: Allow users to change their own password
    ... Don't use macros except for the very few things, ... no other easy way (eg. AutoKeys). ... Instead, use VBA, as Jack suggested. ... Prev by Date: ...
    (microsoft.public.access.security)
  • RE: Run Macro on close
    ... I'm not sure where to find the VBA, only the Macros. ... "FSt1" wrote: ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • Re: How to show old macros?
    ... The problem is that the macros are not written ... in VBA, but written in XLM. ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • Re: Find and Replace with VBA
    ... I'm new to VBA in Word so I wasn't sure where to insert your code ... fragment. ... Loop ... Prev by Date: ...
    (microsoft.public.word.vba.general)