Consulting

Results 1 to 5 of 5

Thread: Macro Compatibility Issue between Excel 2003 and Office 365

  1. #1

    Macro Compatibility Issue between Excel 2003 and Office 365

    Hi,


    I have an Excel file that uses macros from Microsoft Excel 2003. We are having compatibility issues between it and our new version of Excel from Office 365. When opening an office 365, excel simply does not respond and does not open the file.


    Is there any way to update the file so it is compatible with Office 365?
    Any help would be appreciated in this regard. Thank you.

  2. #2

  3. #3
    Administrator
    VP-Knowledge Base
    VBAX Grand Master mdmackillop's Avatar
    Joined
    May 2004
    Location
    Scotland
    Posts
    14,489
    Location
    Please post your file using Go Advanced/Manage Attachments

    Edit: OK, File eventually came through
    MVP (Excel 2008-2010)

    Post a workbook with sample data and layout if you want a quicker solution.


    To help indent your macros try Smart Indent

    Please remember to mark threads 'Solved'

  4. #4
    VBAX Sage
    Joined
    Apr 2007
    Location
    United States
    Posts
    8,724
    Location
    @greenbcz

    1. That was a 10MB+ file

    2. I can save and open it using 360

    3. I tried running some of the macros and they at least seemed to do something

    I re-saved as new format on my Google Drive because of it's size (3MB); I'll PM you the link and you can see if it helps

    I'll leave the file there for a couple of days
    ---------------------------------------------------------------------------------------------------------------------

    Paul


    Remember: Tell us WHAT you want to do, not HOW you think you want to do it

    1. Use [CODE] ....[/CODE ] Tags for readability
    [CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
    2. Upload an example
    Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
    3. Mark the thread as [Solved] when you have an answer
    Thread Tools (on the top right corner, above the first message)
    4. Read the Forum FAQ, especially the part about cross-posting in other forums
    http://www.vbaexpress.com/forum/faq...._new_faq_item3

  5. #5
    VBAX Newbie
    Joined
    Jul 2020
    Posts
    1
    Location
    Did your problem solve? I am also facing same problem for macros

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
  •