+ Reply to Thread
Results 1 to 2 of 2

Fixing corrupted files for VBA

  1. #1
    Registered User
    Join Date
    United States
    MS-Off Ver

    Fixing corrupted files for VBA

    I have a code that's supposed to open up a recently downloaded file, and copy and paste an entire sheet within it. I'm getting an error because the file was partially corrupted and excel-repaired. I've read that the best way around this is to re-save the excel file. Does someone have an idea for a macro that will re-save the file for me?

  2. #2
    Forum Contributor
    Join Date
    MS-Off Ver
    Excel 2010

    Re: Fixing corrupted files for VBA

    The file is partially corrupted because you downloaded it from the internet. It's probably not corrupted per se. It's a bizzare little security feature that Microsoft didn't document too well, that basically prevents you from opening Excel files that may contain malicious code - i.e. you can't open it from an internet source, until you copy to another folder.

    Ron De Bruin has a lot of info about copying or moving files and folders: http://www.rondebruin.nl/win/s3/win026.htm


+ 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. My Excel 2007 Files seriously corrupted
    By NealReyd in forum Excel General
    Replies: 4
    Last Post: 01-27-2022, 04:47 AM
  2. HELP! Corrupted files
    By Hannah14 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-08-2016, 11:57 AM
  3. Fixing Corrupted Files
    By MountainGoat in forum Excel General
    Replies: 0
    Last Post: 11-18-2008, 01:22 PM
  4. Recovering corrupted files
    By BadgerMK in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-08-2006, 11:52 AM
  5. [SOLVED] fixing corrupted files in xls format
    By Mike in forum Excel General
    Replies: 1
    Last Post: 04-30-2006, 02:15 PM
  6. files corrupted after installing office sp2
    By y.i in forum Excel General
    Replies: 4
    Last Post: 03-08-2006, 03:25 PM
  7. [SOLVED] my excel files have got corrupted
    By Manish in forum Excel General
    Replies: 0
    Last Post: 01-31-2006, 09:40 AM

Tags for this Thread


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