1. O

    64 bit issue

    Hi I'm working in 32 bit Excel but I'm getting error in Excel which is 64 bit. How do I edit the codes in 64 bits. Public db As DAO.Database Public rs As DAO.Recordset Public sql As String Declare Function sndPlaySound32 Lib "winmm.dll" Alias _ "sndPlaySoundA" (ByVal lpszSoundName As String, _...
  2. auto.pilot

    Seeking VBA method to filter multiple values

    I have the following bit of code which is part of a larger project. Near the top, I have identified TheClient as a single cell reference. Within the code, a workbook is opened, then filtered by TheClient in column A. Thereafter, the headers and filtered range are copied and then pasted to the...
  3. A

    32 bit to 64 bit Macros

    Let me start off by saying that I am very much a novice to VBA, Macros, Excel and Access. But here it goes. At work we have an Access database and an Excelmacro sheet. They work together and they were both built in a 32 bitsystem. They are upgrading us to Win 10 64bit and Office 2016...
  4. kelly mort

    General knowledge on datepicker - 32 bits vs 64 bits compatibility

    So I developed a few problems with datepicker in excel currently then I have to do more reading about that object.What I found was that it does not work well on the 64 bits office versions.When I tried testing it on 64 bits office version, it said it couldn't load the object. Then when I went to...
  5. A

    32 to 64 bit

    Someone has asked if an App I have can work in their 64 bit Office. (I think it's the online one). I installed 64 bit office 2010 onto my laptop to find out. Running the xlsm file brings up a pile of problem but I did manage to alter all the Functions to ptrsafe Functions. Then there are lots...
  6. R

    email area using Yahoo

    Hi guys, Hoping you can help me, I have a range of cells on a sheet A1:H32. I want to automate copying this area as a bitmap and sending to multiple recipients using my yahoo email. Does anyone have a bit of code for this please? Thanks Fletch
  7. V

    VBA Formula

    Hi All Thanks in advance, I have the following sheet Excel 2010 32 bit ABCDE 1S.No.25689365478256925698 22564214514251478 3 41255820 5230101023 6335201226 7440301429 8545401631 9650501833 107551936 1186039 1296541 13107042 141143 1512 Sheet: Sheet1 and need the...
  8. K

    Split Access Database Keeps Crashing

    We recently upgraded all our systems to Windows 10 64 bit and Microsoft Office Professional 64 bit. We were using a split access database with Office 2013 which was working perfectly. Since the upgrade, when using the database on one of the systems, it constantly crashes and then Access...
  9. Johnny C

    XL2016 When I delete a series that series stays and the rest disappear?

    Different issue to the previous one but vaguely related. I have charts set up in XL2013 32 bit, I've now got XL2016 64 bit with secondary axis. When I select a series and click (or press) delete, that series stays but all the others disappear. Doesn't matter which axis they are on. When I...
  10. T

    Macro to adjust a textbox to the size of the text

    Hi Everyone, I've been playing around with activex text boxes and have found I can adjust the height as I type. so what I would like is a bit of code that can adjust the textbox to one line bigger (or the size of the text i'm tying in I have this bit of code that will resize the text box so I...
  11. M

    cannot find library

    Hi, I believe (but am not sure) that there is a problem with the compatability of the 64 bit vs. 32 bit settings. I am trying to run a macro and am getting the error "Cannot find library" ... then I am prompted to choose the "references - VBA project". How do I fix this? I don't care if the...
  12. V

    Adding Column - VBA

    Hi Thanks in advance, i have the following sheet Excel 2010 32 bit ABCDEFG 1 230252004199.002479 330202003199.002478 430231999199.002477 53024199570.002480 64751994105.002607 730211993220.002606 81662197790.002609 930191970150.001363 1030181961185.002557...
  13. A

    Macro 32bit vs 64 bit

    Hello. I'm unable to use a macro in a 64 bit version of excel that works in the 32 bit version of Excel. MS's documentation says the following. Can someone provide the known declarations that need to be changed or point me to documentation that say which declaration statements need to be...
  14. M

    ActiveX button Not Working

    I have a few active-x buttons in a .xlsm file that I sent to a coworker. He can execute the macros manually so I know macros are enabled but when he clicks a button the button shape and text appear briefly above the actual button and a bit to the left and then vanish and NOTHING ELSE HAPPENS...
  15. A

    How to stop a Macro-Enabled Template from saving and adding a "1" to the file name

    Is there a setting or a macro that could disable the auto function of a macro-enabled template from adding a number? I have a workbook that is used for every bit of work done in house, and is copied many times. I chose to use a template to discourage anyone from making edits to the original...
  16. M

    Why does assignment needed to be on LEFT-hand side?

    I am starting to learn VBA. On this For/Next loop, I am stumped by one line of code: If myValue > 400 Then Range("F" & i).Value = myValue + 10 I get the first part: If myValue > 400 Then but I do not understand the second part: Range("F" & i).Value = myValue + 10 Why must I use...
  17. R

    Office 365 Insiders Excel 64 bit Userform Date Picker

    Hiyas, I have a spreadsheet where there's a field in my table for a date. Currently, I'm entering in the date manually but, I wanted to try my hand at creating a userform with VBA and for the date, I wanted a date picker. Sadly, I've learned that 64 bit Excel doesn't have a built in date...
  18. T

    Help with adding comment from scripting dictionary item

    I'm using this code, although I've amended it a bit and one of the things that I want to do is to get it to add a comment in to a cell With CreateObject("scripting.dictionary") For Each Cl In Ws2.Range("A2", Ws2.Range("A" & Rows.Count).End(xlUp)) If Not...
  19. B

    Bit of a Tricky One

    Hello, I have a bit of a tricky one, maybe. I have formulas in both cells A1 and B1 that will either return a value or be left blank. What I would like to do is create another formula in cell D1 that returns the value of cell C1, but only if either cells A1 or B1 have values in them (not...
  20. B

    Append function for multiple files only possible for 2 files in Power Query/Excel 2016/64 bit?

    Hi i have worked before with Excel 2013/64 bit and used Power Query and the function Append, in order to consolidate data from multiple Excel files into one file. Now when i use the built-in Power Query in Excel 2016/64 bit i do not have the opportunity in Append to consolidate more than 2...

Watch MrExcel Video

This Week's Hot Topics

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