64bit

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...

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...

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...

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...

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...

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...

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

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

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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