64-bit

Hello, I was using 32-bit Excel 2013 and had a workbook with a number of bespoke functions, some simple, some not so simple. However, after upgrading to 64-bit Office 365 all of my bespoke functions do not seem to be working. Here is example code to work out the inverse of the tangent...

I use the following code to return the owner username of network files. It works perfectly in 32-bit Excel, even on 64-bit Windows. In 64-bit Excel, no error is thrown, it simply doesn't return anything. Thoughts? Set objWMIService = GetObject("winmgmts:") Set objFileSecuritySettings =...

Hi Experts, I am unable to find the ListView control in Additional Control or in Toolbox of Userform. I surfed thru Google and tried a few steps still unable to find it. Please help me where did I go wrong or is their any other solution for this? In our office, we are using: MS Office 2016...

Hi My computer OS is 64-bit, windows 10. My excel is 365. When I tried =INFO("OSVERSION") I got <tbody> Windows (32-bit) NT 10.00 </tbody> Why is that? thank you very much.

In Excel 2016 I am trying to use the "move and click mouse" macro listed in the below link that simulates mouse click actions in Excel via VBA. Link: https://excelhelphq.com/how-to-move-and-click-the-mouse-in-vba/ However, after pasting this code in to VBA the first two lines of code are...

I'm trying to get powerpivot installed on my system, but the installations goes all the way to the end before popping: I'm installing this on Win7 64bit with Office 2010 64-bit using 64-bit installation file from MS. Any help as I've re-installed VC Redist files as well as .Net Framework and...

Hi all, I have found several "old" posts on different fora stating code for making the mouse wheel scroll in listboxes on a userform. However... they are all written in a time pre-64-bits and do not work on my "modern" system. Can anybody help me out with a set of modules and codes to make it...

I've written some code to use wininet to list and then later download a variety of files on an FTP site. When using Microsoft Office 2010 32-bit the code works fine; however, when using Office 2013 64-bit the program returns garbage info in the WIN32_FIND_DATA type. The correct results when...

I have a process that runs all day, gathering data from the web, storing that data on an xlsx file, closing that file, and starting another xlsm book that further process the data while the original process goes back for more collection ( collection of other "parts" of the whole range of data...

32 bit Excel 2013 installed on a Windows 7 64-bit machine. What are the limitations? It seems my macro's do not execute as fast. If I understand correctly, with 64 bit Excel can use 4 processors for performance, while 32 bit is limited to 2?? Anyone more knowledgable about this let me know if...

Hi there, I have a really bizarre problem with a macro I've written which appears to simply stop executing at a certain point in the code. I am using a 64-bit install of Excel (part of Office Pro Plus edition). This is the code I've written: Sub prepBudget2013forFDM() Debug.Print...