• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

32 bit vs 64 bit

TiffanyMarie264

TiffanyMarie264

New Member
Hello!

I have some VBA coding that basically does format checking and then extracting of a file to put it in the format to upload into our general ledger system. I currently use a 32 bit version of excel. However, we recently acquired a company that will need to use the same template with the VBA, but they operate on a 64 bit system. What are the main differences in the VBA coding, and will it be difficult to translate the coding from one version to the other? Is there anyway to get the 32bit VBA to work with the 64 bit version of excel?

Sorry if this is vague, but I am completely new to this concept! Any help would be appreciated. Thank you!
 
See link for details specific to VBA
https://msdn.microsoft.com/en-us/library/office/ee691831(v=office.14).aspx

Other differences:
  1. You will need appropriate driver for connecting to worksheet/database (ex. ACE Engine 32bit/64bit)
  2. You can't connect to 32bit Office application when using 64bit Office application (i.e. You can't connect to 32bit Access using 64bit Excel)
  3. Certain ShellCommand will need full path, or it can confuse 32bit/64bit variants (ex. Telnet.exe)
There are other differences, but I think above are the major ones.
 
You must log in or register to reply here.
Back
Top