+ Reply to Thread
Results 1 to 4 of 4

Open file Problem for excel macro

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    10-02-2012
    Location
    malaysia
    MS-Off Ver
    Excel 2016
    Posts
    140

    Open file Problem for excel macro

    Hi..

    I have a excel macro file ..with vba code inside..

    But now I can't open the file and show the message
    "The file format or file extension is not valid.."

    I have attached the file in here..


    Thanks
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: Open file Problem for excel macro

    You have two file extensions in the filename, try renaming it:
    "UP1.xlsm"

  3. #3
    Forum Contributor
    Join Date
    10-02-2012
    Location
    malaysia
    MS-Off Ver
    Excel 2016
    Posts
    140

    Re: Open file Problem for excel macro

    Ok..
    But after i change the file extension still the same is happen
    The file can't be open..
    the message it's show
    "The file format or file extension is not valid.."
    I have add the file after change the extension
    Thanks
    Attached Files Attached Files

  4. #4
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,794

    Re: Open file Problem for excel macro

    I think your file is really messed up and I'm not sure you can recover any data from it unless you google for some 3de party software that may be able to handle this problem.

    Tried to open it as UP1.xlsm, UP1.xlsx and UP1.xls no go. Tested also using "Open Office" but that did not work either.


    Alf

+ 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. Replies: 0
    Last Post: 10-02-2013, 01:47 AM
  2. macro to open, copy paste from existing excel file to a new blank file
    By 2blessed in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-15-2012, 06:05 PM
  3. [SOLVED] Problem to re-open original file after save as macro has run
    By Luli in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-28-2012, 01:08 PM
  4. macro prompts immediately to open a file once the Excel file with the macro is opened
    By jhmayor03 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-03-2012, 10:00 AM
  5. Excel Macro to open explorer, open csv file
    By Trubble in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-13-2009, 04:54 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