View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dutch76[_2_] Dutch76[_2_] is offline
external usenet poster
 
Posts: 4
Default Opening files by VBA

Hello,

I want to open Excel-files (one by one) that are in a certain directory.
With the opened files I want to do some calculations by means of a VBA macro
which is stored in a already opened workbook. After the calculations the
files are closed again.

How do I manage to open the files one by one from the macro?

An answer to this would be very helpful...