+ Reply to Thread
Results 1 to 2 of 2

Automatically opening files, running a script and saving it, Thank you

  1. #1
    Registered User
    Join Date
    08-13-2017
    Location
    London
    MS-Off Ver
    2010
    Posts
    21

    Thumbs up Automatically opening files, running a script and saving it, Thank you

    All,

    I have 200+ files located in a folder, which have random file names.
    I need to open each file, run a script which reformats the file and then save the file as 1...200 i.e. save the first file as 1., the second one as 2. etc. in another particular folder.

    Is there a way I can do this in VBA?

    Thanks!

  2. #2
    Valued Forum Contributor ranman256's Avatar
    Join Date
    07-29-2012
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    1,173

    Re: Automatically opening files, running a script and saving it, Thank you

    usage:
    getFilesInDir sourceFolder, targetFolder
    getFilesInDir "c:\temp\", "c:\other\"


    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Tweaking A Powershell Script for Opening CSV Files as Text
    By scott123 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-04-2016, 02:58 PM
  2. [SOLVED] Opening and saving files that have a date in the file name
    By jgscanlon in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-08-2014, 03:32 PM
  3. Saving as pdf files from opening an excel files
    By djfscouse in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-29-2013, 12:38 AM
  4. Opening data files within zip files automatically
    By HandL in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-09-2008, 10:48 AM
  5. Fix for problem opening/saving files
    By Patricia Shannon in forum Excel General
    Replies: 2
    Last Post: 04-25-2006, 03:40 PM
  6. Running a Script upon Saving a File
    By Michael in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-12-2005, 03:05 PM
  7. [SOLVED] Opening and Saving Groups of Files
    By NacellesEng in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-16-2005, 12:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1