+ Reply to Thread
Results 1 to 2 of 2

Functions not recognized (error) in Excel 2013 64bit,

  1. #1
    Registered User
    Join Date
    08-29-2012
    Location
    Sofia, Bulgaria
    MS-Off Ver
    Excel 2010
    Posts
    6

    Functions not recognized (error) in Excel 2013 64bit,

    Hi!
    I have developed a small application in Excel 2010. As I need to show in a separate form images of charts and a worksheet (I don’ want the worksheet to be editable at all), I save them as a picture file in meta (or png) format and then load in an image object on the form.
    For the purpose I use a module, developed by Stephen Bullen, called “modPastePicture”.
    This application works perfectly in Excel 2007 – 2010 and 2003 as well.
    Yesterday I tested in Excel 2013, on a new 64 bit computer and it could not compile the code. The error message said in short “Your code is not compatible with 64-bit engines … redesign” and the error was on the Public Declare Function rows of this module and on the same some declarations of other modules where I use “foreign” functions.
    Can anyone advise me how to avoid the functions (or the libraries ?), or how to make this compatible to 64-bit systems?
    I am attaching the module as this is more important, the other modules I can redesign without the “foreign” functions.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    08-29-2012
    Location
    Sofia, Bulgaria
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Functions not recognized (error) in Excel 2013 64bit,

    Searching for solution, I came upon something in the VBA help :
    In order the Declare statement to operat correctly on 64-bit MS office, one need to add the ptrSafe argument. Now the error is on other lines (The code has only the vbCrLf argument) and it is " Library missing" ... does someone know what libraries from 32 bit systems are missing in 64-bit? Or maybe the problem is that the standard sysrem libraries are in the system32 folder? Sorry for bordering, but I don,t have teh 64 machine wwith mw, and my communication with my friend (who tests now) are by phone and mails

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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