Compile Error:

Posted on 2012-08-24
Last Modified: 2013-03-03
While booting up excell, I get this error message.

Compile Error:

The code in this project must be updated for use on  64-Bit systems. Please review and update Declare statements and then mark them with the PtrSafe attribute.

I looked on microsoft's website they told me to just boot up in 64 bit office, which is not possible.
Question by:BladeValant546
    LVL 33

    Expert Comment

    Is this your project?

    Author Comment

    It is for a client, not mine directly he is using normal excell and outlook. However, he is using Pipe-flo, which is an engineering program.

    Accepted Solution

    Apparently the solution was to follow exactly what the error code said to do. I did a find/replace for all the instances of "Declare function" and replaced with "Declare PtrSafe function" then saved the file. It no longer pops up.

    Weirdest thing I've ever seen, not even reinstalling Excel fixed it.

    Author Closing Comment

    There was no other apparent solution and this solution completely resolved it. Still unsure as to why it happened in the first place.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    I wanted to share this with fellow Experts, who might not know. How often have you wanted to learn something, only to be set back by either restrictions imposed on "trial" or "evaluation" software?  How often have you had to rebuild a home networ…
    Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
    The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
    The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now