+ Reply to Thread
Results 1 to 4 of 4

32 V. 64BIT excel

  1. #1
    Registered User
    Join Date
    01-16-2016
    Location
    Canada
    MS-Off Ver
    2016
    Posts
    18

    Angry 32 V. 64BIT excel

    Hello every one. Have a problem with 32 bit v. 64bit. On my desk top I have 32bit excel. on my lap top I have 64bit excel. when opening file with 64bit I am getting an error saying I need to update declare statement and mark with PtrSafe attribute. I have attached the in red code in question.

    Please Login or Register  to view this content.
    It is the function part of the code that is being highlited as an error.

    Thank-you

    Cheeco

  2. #2
    Registered User
    Join Date
    01-16-2016
    Location
    Canada
    MS-Off Ver
    2016
    Posts
    18

    Re: 32 V. 64BIT excel

    Thanks everyone. I have figured out how to update the file. It is working now.

    Chow

    Cheeco

  3. #3
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: 32 V. 64BIT excel

    Care to share?
    If posting code please use code tags, see here.

  4. #4
    Registered User
    Join Date
    01-16-2016
    Location
    Canada
    MS-Off Ver
    2016
    Posts
    18

    Re: 32 V. 64BIT excel

    Sorry about that. Yes I will be happy to share. One must insert the word PtrSafe before the word Function in each of the lines in question.

    Please Login or Register  to view this content.
    This will correct the problem. Well it did for me. Hopefully the same results for others.

    Chow

    Cheeco
    Last edited by Cheecochongo; 01-27-2016 at 08:11 PM. Reason: RESOLVED

+ 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. How to read custom props on closed file (64bit Win Server, 64bit Excel)
    By soundneedle in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-14-2015, 01:25 AM
  2. Change registry settings for IE 64bit in 64bit environment
    By dgdgdg in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-30-2014, 07:56 AM
  3. Reporting from Excel 64bit using VBA
    By Bezzie in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-22-2013, 02:45 AM
  4. Replies: 3
    Last Post: 11-23-2012, 01:57 AM
  5. [SOLVED] Vba not working in 64bit excel - Please help
    By sthiru in forum Excel General
    Replies: 1
    Last Post: 09-20-2012, 10:53 AM
  6. Excel 64bit /Intel CPU cache
    By triniti in forum Excel General
    Replies: 0
    Last Post: 11-08-2011, 02:24 PM
  7. [SOLVED] 64bit XP Pro and Office 2003 excel glitches?
    By LJS in forum Excel General
    Replies: 0
    Last Post: 12-16-2005, 12:45 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