+ Reply to Thread
Results 1 to 2 of 2

Declare variables to work in 32 and 64 bit versions of Excel VBA??

  1. #1
    Registered User
    Join Date
    10-31-2011
    Location
    Tyne and Wear
    MS-Off Ver
    Excel 2007
    Posts
    5

    Post Declare variables to work in 32 and 64 bit versions of Excel VBA??

    As the title states I have been asked to look at some code for an unrelated matter to my issue.

    The end user uses 32bit Office and I have 64bit Office which has resulted in my not being able to run through his issue:

    Please Login or Register  to view this content.
    How do I firstly update this code to work with my 64bit version and also how could I ensure it is then compatible with both?

    Any help on this matter would be greatly appreciated.

    Thanks

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,924

    Re: Declare variables to work in 32 and 64 bit versions of Excel VBA??

    Check out this article on the matter.

    http://www.jkp-ads.com/articles/apideclarations.asp
    Cheers
    Andy
    www.andypope.info

+ 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] VBA Declare Variables with array
    By bkeat in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-24-2014, 11:35 AM
  2. [SOLVED] How do you declare several variables?
    By bananajelly in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-22-2014, 05:43 PM
  3. How do you declare several variables?
    By bananajelly in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-22-2014, 11:55 AM
  4. [SOLVED] How to declare variables
    By nav505 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-24-2013, 01:25 PM
  5. XL and MS QUERY : How to declare variables ?
    By berapard in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-01-2013, 02:18 AM
  6. Why declare variables
    By tryer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-17-2009, 12:03 PM
  7. [SOLVED] declare Variables
    By Lee in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-16-2005, 05:05 PM

Tags for this Thread

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