microsoft

Hello, can I ask for help your help. I find it hard to solve the percentage of Lost Calls by date and language. Please see sample below: . below is a sample data, for reference. Wait Time Name Status Call Duration Language Class Date Offered 12/2/2018 00:23:20 00:00:41 LOST 00:00:00...

I am very curious in comparison between Access and Excel the security differences in each. Without the advent of quantum computing, I understand getting into a binary excel file that has a 255 character password is nearly impossible. However, in contrast, ACCDB is clearly not binary format - nor...

These file names are generally all the same but the numbers being completely different and I am just looking to place a ‘I’ at the start of the file name and removing the numbers at the start of it? The old name would be XS123445567_A_RT_Y 34019 and I would like to rename it too...

Can someone help me find a shorter formula. I would like the corresponding row's first column to appear in successive columns in a second sheet. Each F number (ie F1, F2, etc) refers to a person. the cells to the right of each person refer to a job that they will be doing (ie Team 1, Team 2...

Hello everybody, I currently have the following list: I want to create a formula (probably through conditional formatting i'd imagine), that basically says: If the cell 4 turns to the left of any designated cell (A1) in row E is not = blank, color the cell in row E with a red...

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

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

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

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

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

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

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

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

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

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

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.

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

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

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

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