64bit

  1. R

    VBA fOSUserName 64 bit - 32 bit issue

    Hi The code below is meant to retrieve the username in a cell with the formula =fOSUserName() The code works flawlessly on my private desktop with Excel 2019 64 bit. However, the code does not seem to work on my company's desktop with Excel 2016 32 bit, even though the code works on this 32...
  2. M

    compile error 64 bit - Mouse scroll code

    Hi, This code allows me to use the scroll wheel on my userforms. I've been using this bit of code successfully but now i have a 64 bit system and its throwing up the following error: Compile error: The code in this project must be updated for use on 64-bit systems. Please review and update...
  3. R

    ADO Recordset empty on Office 2016 64bit (excel)

    Hi All, Thanks in Advance I am having issues with a script that I am trying to run, when I run a simple query it prints out the result but when I query any table on the DB it does show anything and prompts me an error. I ran both queries on PL/SQL and got the correct results, any ideas why it...
  4. F

    excel 365 64 bits profiler

    Hi all, I have a workbook that became very slow. I would like to use a profiler to help me spot where it slows down. I got some VBA code (please see below), but all it is for 32 bits Excel, that s asks for 64-bit in the first 4 lines. Because I am beginner I can´t fix it. Does someone know...
  5. K

    why would a 64bit windows still trip over this code(when all the code that wasn't compliant has been removed?)

    Its really frustrating. I originally had 'DTPicker' in my workbook that is used to enter and track incidents for my company. But, there are a handful of machines that are 64bit, and I couldnt find any compliant date picker modules that would work... so I finally gave up and just have a simple...
  6. P

    Detemine by VBA if Excel is 64 bit or 32 bit

    Hi I have looked through the old posts on this and I a not clear that this is checking for Excel I want to perform actions based on 32bit or 64bit version of Excel not machine capability I have 2 users both using 32bit Excel but 1 has 32bit operating system and the other 64bit. #If Win64...
  7. S

    How we can read httponly cookie using vba from 64bit

    can you help me in - How we can read httponly cookie using vba from 64bit - path=;Path=/;HttpOnly;; secure myIe.Document.cookie and InternetGetCookieEx are not working
  8. G

    vba to find Screen size in 64bit environment

    Hi all. Can someone show me how to get the screen metrics when using a 64bit version of Excel i.e. where do I use "long" and where do I use
  9. F

    DTpicker on 64bit

    I'm using a userform where a date is selected from DTpicker. I developed it initially on 32bit so I didn't encounter this issue. In an attempt to make it work on 64bit I downloaded add-in from Date Picker Add-in for Excel for Windows But an error comes up when calling the procedure in a...
  10. L

    VBA Code to move windows via call to API

    Good afternoon, Can anyone provide me with the code required to find the screen co-ordinates of any window, searchable by its window name as it would appear in appActivate() for example? I know nothing about using APIs to find windows, nor handles etc., and the numerous threads I have read...
  11. E

    ERROR - Object reference not set to an instance of an object - What is this???

    I receive this error message in Excel at lease 4-5 times a day while opening a spreadsheet. I am not doing anything special, no macros, no large workbooks, and nothing that contains advanced formulas. I just click on a regular xls or xlsx doc and I get this error message and a blank page. When I...
  12. K

    Link betweek SQl and EXCEL via VBA

    Hello All, This is my first post and I got an Issue - Hopefully it will be a good start for me on this forum - Issue: I'd like to program Select statement in VB where I have Querytext which is 'Select' statement and 'From' part - and then there is 'where' part - The first part will remain...
  13. W

    2010 32bit crashes in 2013 64bit

    Hello All I've developed an application in Excel 2010 32bit. It has 20+ spreadsheets containing data and equations, and I've created userforms to enter the data for those spreadsheets. These userforms consist primarily of text boxes. You enter the data in the text box and then click a command...
  14. R

    Issues with VBA on Win7 64bit

    Hi everybody, I have read everywhere that many people had a trouble like the one I am going to tell you, but could not really find a solution that might fix my problem. Basically: I wrote an easy macro that opened, copied and pasted a given webpage on the active sheet. It has always worked...
  15. R

    Help! VBA/Macro is not working after my computer upgraded to Windows 7 64Bit.

    Hi, I am very new to VBA/Marco for Excel. I’ve been using a Macro created by someone else at work (he no longer works here.) The macro worked like a charm until my computer upgrade from a 32Bit Windows XP to a 64Bit Windows 7. I downloaded and installed the updated version of Win32API.txt from...
  16. K

    Excel Standalone with Office 2013

    Hello -- I am new to this board -since this is more of an EXCEL question vs PowerPivot - I am posting here-although along time ago I used to be on the Excel Newsgroups I have a question with my scenario so I don't waste time/money. I have Office 2013 Home Premium (University) 32 bit Edition...
  17. H

    Excel 32bit crashes on refresh macro on a 64bit pc

    I have a spreadsheet with drop down criteria that queries a database. A 'command button' prompts the user to 'refresh' the data. The macro is very simple. ' ActiveWorkbook.RefreshAll ' When 'clicked' on a 64 bit pc - Excel crashes. The only way out is to 'End Process' via Task Manager. If I...
  18. D

    Excel 64bit: ActiveX component can't create object

    I've been using a COM dll in all previous versions of XL but now that I'm running Office 2010 64bit I get the error "ActiveX component can't create object" when I try to instantiate the object from the linked library <code> Set mCrypKeyObj = New CrypKeySDK7 </code> The library comes...
  19. S

    excel 2010 64bit and file sizes and compatibility

    I have 64 bit windows ultimate and 2010 excel 64 bit... I have a program that exports data (approx 777,343 rows of data) in standard .xls format.... when i open it in excel, i can only see 64k rows and am in compatibility mode... Does anyone know how i can view all 777K rows? thanks

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top