+ Reply to Thread
Results 1 to 3 of 3

Change the Excel extension in a specific drive using code

  1. #1
    Registered User
    Join Date
    11-28-2010
    Location
    egypt
    MS-Off Ver
    Excel 2016
    Posts
    45

    Change the Excel extension in a specific drive using code

    Good evening everyone on the forum.
    I have a code that isn't my own.
    Its purpose is to change the extension of Excel files in a specific drive.
    What is required is that the code is slow. Is there a faster code or add-ons to the code that will speed it up?
    Please Login or Register  to view this content.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2505
    Posts
    27,272

    Re: Change the Excel extension in a specific drive using code

    This code is not just changing the extension, it is changing the Excel file format. This must be done by opening the file in Excel and re-saving it as the new format. Opening, saving, and closing files is time-consuming and there is no way to speed it up. It might be possible to make some of the code a little more efficient but those improvements would be negligible compared to the file operations.

    (P.S. I am making a trip to Cairo this October insha'allah)
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    11-28-2010
    Location
    egypt
    MS-Off Ver
    Excel 2016
    Posts
    45

    Re: Change the Excel extension in a specific drive using code

    Thank you very much 6StringJazzer

    Is it possible to make improvements, especially in file searches?
    The number of files in general may be large, but the number of Excel files with the required extensions is limited.

+ 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. vba code to copy specific pdf files to a specific folder which is scattered on drive
    By JEAN1972 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-18-2022, 03:54 PM
  2. Loop through all files in a folder with a specific file extension and save in excel
    By akwishestofish in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-12-2019, 05:43 PM
  3. Change my vba code to save excel file directly to any users desktop not via c drive
    By galbatrox9 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-22-2016, 01:22 AM
  4. [SOLVED] Please help in modifying this Code to change the extension from .xlxs
    By sai0449 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-10-2015, 12:23 PM
  5. Replies: 3
    Last Post: 06-20-2013, 11:10 AM
  6. Email Out of Excel Code no longer working due to update or drive change.
    By Kidcarlosuk in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-12-2012, 06:37 AM

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