+ Reply to Thread
Results 1 to 2 of 2

Saving .xlsm file to .xlsx

  1. #1
    Registered User
    Join Date
    06-19-2013
    Location
    Sheffield
    MS-Off Ver
    Excel 2013
    Posts
    86

    Saving .xlsm file to .xlsx

    Hi,
    I'm trying to save my .xlsm file to .xlsx, here is the code:
    Please Login or Register  to view this content.
    I get a run time 1004 error saying that is not possible to access the file, any help?
    Thanks

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Saving .xlsm file to .xlsx

    date default format = dd/mm/yyyy (should be for UK)

    you cannot save files with "/"

    just wrap the date with something like
    Please Login or Register  to view this content.
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ 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: 05-20-2014, 12:01 PM
  2. Saving xlsm file as xlsx while running macro
    By happygilmore in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-29-2012, 02:32 PM
  3. [SOLVED] Save xlsm file as xlsx file
    By ccpsc in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-06-2012, 01:12 AM
  4. Saving XLSM as XLSX and removing buttons
    By mrmarchuk in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-09-2012, 04:15 PM
  5. Saving .xlsx in a network folder through a .xlsm file
    By jambai in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-18-2011, 04:09 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