+ Reply to Thread
Results 1 to 2 of 2

VBA to look into a folder and resave all files with the same name but as Excel documents

  1. #1
    Registered User
    Join Date
    03-30-2012
    Location
    Grand Rapids, MI
    MS-Off Ver
    Excel 2003
    Posts
    9

    VBA to look into a folder and resave all files with the same name but as Excel documents

    At work, an Oracle database sends me emails with spreadsheets in them. These get peeled out of my email and saved in a folder on my computer using an agent in Lotus Notes (our email system). Although you ask the database to send this to you as an Excel file, it really comes through as a single file web page, even though it acts and behaves as an Excel File.

    What I need is a macro to look into this folder and save any document in there as an Excel file, without changing their name, although it wouldn't be the end of the world if it did. Apparently it is not possible to save them as a certain file type when they are extracted out of my email and saved using the agent.

    If it only processed non Excel files, that would be fabulous, but not that big of a deal if it didn't. MS Access won't communicate with Single File Web Pages (to my knowledge), so that is why this would be useful to have them converted to Excel files without having to go in and resave them manually.

  2. #2
    Valued Forum Contributor tlafferty's Avatar
    Join Date
    04-08-2011
    Location
    United States, Tacoma, WA
    MS-Off Ver
    Excel 2010, Excel 2013 Customer Preview
    Posts
    1,112

    Re: VBA to look into a folder and resave all files with the same name but as Excel documen

    This is probably blasphemy, but I wouldn't suggest using Excel to do this. Take a look at PowerShell and the GetChildItem commandlet - it should give you all you need for file management, and it's lightning fast...
    http://4sysops.com/archives/powershe...-and-pipeline/
    If your question has been satisfactorily addressed, please consider marking it solved. Click the Thread Tools dropdown and select Mark thread as solved.
    Also, you might want to add to the user's reputation by clicking the star icon in the lower left corner of the post with the answer- it's why we do what we do...

    Thomas Lafferty
    Analyst/Programmer

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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