none
open 1st file run macro close open next file run macro..... RRS feed

  • Question

  • Hello all

    i am trying to find a macro that will open the first file of 73, run a macro "tidy"thne save an close it then open next one run "tidy" and so on through all 73.

    can anyone get me started

    sub openall()

    dim anaddress as string

    anaddress = vba.dir ("c:\plan*.mpp")

    do while not len(anaddress) = 0

    fileopen ' but this give me the open window i'd like to open the file without this the window

    tidy

    filesave

    fileclose

    anaddress = VBA.dir

    loop

    end sub

     

    can some one tell me what i am missing please

     

    regards

    Phil Monckton

    "a frustrated tinkerer"

    Wednesday, June 22, 2011 4:43 PM

Answers

All replies