+ Reply to Thread
Results 1 to 3 of 3

ShellExecute VBA7 declaration compile error in O365

  1. #1
    Forum Expert
    Join Date
    07-23-2018
    Location
    UK
    MS-Off Ver
    O365 32bit (Windows)
    Posts
    2,026

    ShellExecute VBA7 declaration compile error in O365

    In a standard module I have the following declarations for ShellExecute to allow its use in both 64 and 32bit versions of Excel


    Please Login or Register  to view this content.
    In Excel 2007 32-bit, there is no problem.

    However, users with Excel 32-bit (build "16.0.12228.20100") as part of Office 365 receive a compile error. When manually compiling on one of these machines it highlights the vba7 declaration (above, in red).

    Does anyone know why this is causing a compilation error in Excel 365 and how I can have declarations for both 32-bit and 64-bit?

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,895

    Re: ShellExecute VBA7 declaration compile error in O365

    64 bit declaration is off...
    Please Login or Register  to view this content.
    This should be...
    Please Login or Register  to view this content.
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

  3. #3
    Forum Expert
    Join Date
    07-23-2018
    Location
    UK
    MS-Off Ver
    O365 32bit (Windows)
    Posts
    2,026

    Re: ShellExecute VBA7 declaration compile error in O365

    Perfect, thank you! I still get confused by the 64 bit types.

+ 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. [SOLVED] xlsm modified on o365 generates compile error
    By HarryKlein in forum Excel General
    Replies: 4
    Last Post: 10-11-2018, 04:17 AM
  2. Macro / Compile Error / Duplicate Declaration
    By carl in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  3. [SOLVED] Macro / Compile Error / Duplicate Declaration
    By carl in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  4. Macro / Compile Error / Duplicate Declaration
    By carl in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 04:05 AM
  5. [SOLVED] Macro / Compile Error / Duplicate Declaration
    By carl in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  6. Macro / Compile Error / Duplicate Declaration
    By carl in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  7. [SOLVED] Macro / Compile Error / Duplicate Declaration
    By carl in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-29-2005, 03:55 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