microsoft

  1. R

    vba code no longer working after 8 years: did Excel or vba change?: lngRowsVisible

    Hi all! In 2011, the kind & infamous Moderator Jerry Sullivan gave me vba to achieve adding or deleting rows to have a proportionate sized sheet to print after filtering rows (in this post...
  2. H

    Help with Macros

    I very new to using Macro. Can some one please help me with a code to open all the below applications once I run the Macro. Calculator Adobe Reader DC Cisco Jabber Microsoft word Micrsoft excel Microsoft power point Microsoft outlook Snipping tool Notepad Any help is really appreciated Thanks
  3. A

    Power BI Certified Courses

    Hi, my company is prepared to put me through a Power BI course and have asked me to find a course that fits our needs: > Preferably a week / 2 week classroom based intense course > Certification included, Microsoft 70-779, MCSA or MCSE exams as part of the course > Preferably a Microsoft gold...
  4. B

    Microsoft Access 14.0 Object Library

    Hi, I have an Access Macro. In this macro, Microsoft Access 14.0 Object Library is ticked in Reference. I want to un-tick this reference. However while doing so I get pop-up as ‘Can’t remove control or reference; in use’. How do I find out what objects in my macro are related to this reference...
  5. A

    help with iif statement in access

    Hi all, I know access is not the best at formulas, but I have certain customer names were they can have the name entered slightly differently ( like Microsoft, Microsoft Inc, Microsoft UK).. Is there a iif contains formula so that if the customer name contains Microsoft then return the word...
  6. S

    Possible to prevent the Microsoft Excel Objects folder tree from expanding on its own?

    Within the Visual Basic Editor on the left side there is the Microsoft Excel Objects folder tree that contains all of the sheets in the workbook. The workbook that I am working in has many sheets and it "pushes down" the Modules folder and Class Modules folder, forcing me to scroll down to see...
  7. M

    ODBC Microsoft Access Driver Login Failed

    Hello All, I have an excel workbook which is linked to an Access Query via the Data>Get Data Essentially, each morning, as new data becomes available I right click and hit refresh and it updates for me. The past couple of days I have started to receive the following: "ODBC Microsoft Access...
  8. J

    microsoft excel has stopped working.

    It always happen when I closed the excel and open it again by clicking the assigned macro
  9. J

    microsoft excel is recovering information

    i cant open my userform becauses of the "microsoft excel is recovering information" .. it will onlly show when i clicked my assigned macro .. can help me guys ? im not an expert of this
  10. S

    Run-time error 3343 - Is there a solution

    I have the following code but have not found a solution online. Has anyone figured out a solution? or would this relate to an authentication issue from my company's server? how do I get around that? I have the following references: Microsoft Access 16.0 Object Library Microsoft DAO 3.6...
  11. P

    VB Assistance with Counting the number of rows with Data (within a datarange)

    Hello - I have a worksheet that will use a datarange of A2:A1000 within a sheet name of "ABC" I would like a variable that will return the number of rows that contain data. Anywhere between 1 and 999 is possible.
  12. T

    error message

    I am using Excel 2019 which I just download from Microsoft. I deleted the old Microsoft office which had word and excel because I was getting an error message. I am trying to enter stock symbols in column A and in column B I have the following =xlqprice(A3, "yahoo"). I have used this formula...
  13. J

    Use VBA to install Excel Microsoft Scripting Runtime Reference

    Hi all! I'm trying to activate the Microsoft Scripting Runtime Reference within my code as I'm using FSOs in other parts of the code. I don't get any errors, but it's not activating the reference either. The path below is my actual path. Any help is appreciated. Thanks in advance! Sub...
  14. rediffusion

    How to use `Google Code Prettifier` to VBA macro in Microsoft Excel?

    Cross-post! I have some VBA macro for "Inserting Note" in Microsoft Excel. I want this prettifier to be inserted in my macro for creating a note with highlighting, is it possible (Interested in highlighting such as on StackOverflow)? Watched a video 1, 2, - on YouTube but the manual is not...
  15. J

    Microsoft office Pro plus 2016

    Hi Guys, I have installed the Microsoft office professional plus 2016 on my personal computer (with a subscription of course) and i signed for the insider. My question is: Is it different from the office 365 pro plus insider?? Curious, because i am using certain keyboard shortcuts like Alt+B+M...
  16. V

    VBA is Adding Microsoft Excel Objects??

    Everytime I am opening my workbook, I am getting a catastrophic failure, and then the Microsoft Excel Objects duplicate on each tab module. What am I doing wrong?
  17. P

    Help with a formula search for text in a cell from a lookup table

    Hi there Newby here so not sure how much/little info to post, moderate excel skills, slowly going mad over a project I really please need help with! I have searched this forum and Google with no luck. Heres my problem - I have a XLS with 20,000+ rows and I need to check if words match a table...
  18. P

    Microsoft Excel (pop-up msg)

    Hello, I'm getting a self generated Microsoft Excel popup message: Is there any way to suppress this self generated Microsoft Excel pop-up message? Please let me know. Thank you! Pinaceous
  19. K

    Microsoft Visual Basic Error 400

    I am using the following code to automate goal seek with an assigned button. Each time I tried to run it I get an error with big red X with 400. Any idea how to fix this? Sub GoalSeek1_Click() Range("E22").GoalSeek Goal:=Range("6000").Value, ChangingCell:=Range("D6") End Sub
  20. A

    Microsoft Date & Time on VBA UserForm

    Hi, Expert I am new in a Excel. I went to get you expert solution for creating a VBA. I Can not Find "Microsoft Date & Time Picker Control 6.0 I Find only Microsoft Outlook Date Control. But Do not work it. Please help.

Some videos you may like

This Week's Hot Topics

Top