+ Reply to Thread
Results 1 to 3 of 3

Open xlsx with macro

  1. #1
    Registered User
    Join Date
    09-22-2014
    Location
    Los Angeles, CA
    MS-Off Ver
    2011
    Posts
    39

    Open xlsx with macro

    Hi All!


    I've found this code that I have assigned to a button to open files. However, the majority of files I need to open are xlsx extension and when I try to add that type I am unable to open them - they are grayed out. Can someone help me with what I am doing wrong or need to change within in the code to allow it to open .xlsx files?

    Any and all help is greatly appreciated. Thank you!!

    Please Login or Register  to view this content.

  2. #2
    Registered User
    Join Date
    09-26-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2007
    Posts
    17

    Re: Open xlsx with macro

    Hi,

    Think mac works a bit different then Windows and looking at you code it comes from Ron's website.
    But i would still like you to check the contents on following link:
    http://www.rondebruin.nl/mac/section3.htm

    And then especially page:
    http://www.rondebruin.nl/mac/mac015.htm

    Scroll down or use search for the .xlsx file format.

    reg.
    Demeter

  3. #3
    Registered User
    Join Date
    09-22-2014
    Location
    Los Angeles, CA
    MS-Off Ver
    2011
    Posts
    39

    Re: Open xlsx with macro

    I found my answer there! Had to add ""org.openxmlformats.spreadsheetml.sheet"" to my code. Thanks so much!!

+ 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: 1
    Last Post: 12-10-2013, 12:11 PM
  2. Replies: 10
    Last Post: 06-20-2013, 01:47 AM
  3. [SOLVED] Macro to open both .xls and .xlsx to remove rows above header
    By thevideoguy2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-13-2013, 10:56 AM
  4. [SOLVED] Open an xlsx with most recent date in filename, run my data pulling macro, then move file
    By alanwu07 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-31-2013, 05:24 AM
  5. Macro to open & close mutiple xlsx files in folder
    By bernard.x in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-20-2012, 06:18 AM

Tags for this Thread

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