Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Forums » Excel Forums » Excel 2007 and 2010 » Regarding Jjesper post: VBA error when using 2007 instead of 2003

Regarding Jjesper post: VBA error when using 2007 instead of 2003

Previous | Next
Latest post Mon, Jul 12 2010 11:35 AM by Jim Cone. 0 replies.

  • Mon, Jul 12 2010 11:35 AM

    • Jim Cone
    • Top 10 Contributor
    • Joined on Tue, Jan 15 2008
    • Portland, Oregon - USA
    • Posts 233
    • Points 3,315

    Regarding Jjesper post: VBA error when using 2007 instead of 2003

    Reply |Contact

    Was not able to add a reply to your original post, so...
    Re:  "...but the macro isnt working here. We use Application.FileSearch to get the files."

    FileSearch was removed from XL2007.  It had occasional problems and MS dumped it.
    The existing "Dir" function can be used instead.
    '--
    Jim Cone
    Portland Oregon USA
    http://www.mediafire.com/PrimitiveSoftware
    • Post Points: 5
Page 1 of 1 (1 items) | RSS
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.