Microsoft Office





Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Share tech news, updates, or what's on your mind.

Sign up to Post

select data


 show all the appear and his    follow  6 weeks

here the file
Free Tool: Path Explorer
LVL 12
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

I would like a formula to count number of values within a range.
Please refer worksheet


Can you please tell me why it gives error? I am trying to print the correspondent number from sheet2
How do I change my settings, so that when I want to open a previous excel spreadsheet, the  tabs show 1 instead of y1?
i have to add throughout the year many sheets to this document.  Is there a way to set up the cover sheet to just add the the additional sheet and keep look at the right cells for the new sheet?
When I open a new file, I want the past files open to be 1 not Y1.
I have a .Net Windows forms program written many years ago, and I don't remember under which version of Visual Studio.  That program references the Excel interop.  My customer has it installed on a network drive.  To my surprise, the installation folder does not have the interop DLL.  I would have thought that years ago when I delivered the program I would have put that there.

Anyhow, they are moving to Win10 machines, still running this with a shortcut to a network drive.  One Win10 machine doesn't work, saying the DLL is not registered, while other Win10 machines work just fine.

I don't know what I'm looking for to try to resolve this.
We are having issues with office 2016 and win 10
When I brought up a newly imaged machine and logged in with a local account for the 1st time I seen all the fonts that word ships with
AS soon as I logged on with a domain account and opened word most of the font are gone
I have group policies for word 2016 but NOTHING to do with any font
This doesn't happen to office 2016 on win 7 machines with the exact same policy!
Its a real problem as a lot of our templates have arial narrow and this is 1 being removed
All is see is arial and arial black!!!
Thanks in advance
Is it possible to filter cells by VBA code?
In one sheet all the tables with filters will be there and in next sheet we have to create one user form window.

In user form window we have to give all the details and if we submit that sheet it should go to first page displays only that data. It has also display the pie chart for the same.

Please help someone....
If coloumn C, column D,Coloumn E, are equal to each other  then put true in coloumnF and if not then put false by vba
kindly see the sample file
Free Tool: Subnet Calculator
LVL 12
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Highlight coloumn B in sheet1 if sheet 1  coloumn B contains sheet2 coloumn B data by vba
kindly see the sample file
what I want is if coloumn B and coloumn C  are equal to each other then in coloumn A put True or False  if equal then True and if not equal then false by vba
Kindly see the sample file
Nothing to do with Table1
what I want is in table2,Table3,Table4 delete the last data by vba
Kindly look the sample file
Migrating 2 Mailboxes to Exchange On-Line they took 8+ hours each?!?!

Exchange 2010 Hybrid Configuration.
50MB up/down Connection to the internet
User 1 - 50K Messages, 6GB Mailbox - 8 Hours 34 Mins
User2 - 86K Messages 5GB Mailbox - 10 Hours 13 Mins
User3 - 7.4K Messages 400MB Mailbox - 33 Mins
Time of Transfer for user 1 was after 5PM, user 2 was after 3PM. People Leave the office at 5PM and don't use Mail-server that much remotely.

For User1 and User2 I received the Following Messages in the Logs.

  • The long running job has been paused temporarily. It will be retried again when resources become available.
  • The job has been paused temporarily due to unfavorable server health, with request throttling state: 'StalledDueToTarget_DiskLatency'. It will automatically resume after '3/20/2018 4:18:37 AM'.
  • The job has been paused temporarily due to unfavorable server health, with request throttling state: 'InitialSeeding'. It will automatically resume after '3/20/2018 5:16:55 AM'.

"StalledDueToTarget_DiskLatency" Isn't the Target the O365 Server?!?!?

I've seen a lot of posts on increasing the concurrency of more than 10 or 20 Mailboxes at once, though not much more than that.
Since the Moves were successful the configuration of the communications between On-Prem and Online should be okay. Though seems like there can be some tweaking to get better throughput?  I have 90 more users to Migrate and I can't do…
Hi Team,

Again sorry for too many questions. Just trying to understand the way for many manual task that is making my life as nightmare.

The requirement is  - I have a 100+excel and word files, where I have search for particular text say "Reviewer" and get the master list which contains the below output -

File name - Reviewer text (Yes/No)..

Again the files are combination of word and excel. where on every documents, we have to update the reviewer name . So i need check if it is updated or not. Checking manually on each file using Find and replace is taking lot time.So, just wanted to see if this can be run on folder wise and get the details in one shot
Hi All,

I have put a toggle button on my Excel ribbon (customUI) to display and change the Sheet Protect status. When the control is clicked, Sheet Protecting for the active sheet is turned On or Off, depending on the current ProtectContents state.
This works fine, also for the onLoad event of the Ribbon, but I also would need the Ribbon control to detect whether a sheet is protected or not when I select or open another workbook/sheet.

How could I detect the ProtectContents state of any sheet (without having to put code in the worksheet.sheetActivate event - as it should also work for foreign files I have no control over) and pass it back to the toggle control, to make it reflect the current Protection status as pressed or not pressed:
Code for the ribbon control:

Option Explicit

Public gbProtectionState As Boolean
Public MyRibbon As IRibbonUI

'Callback for customUI.******
Sub ToggleProtection(ribbon As IRibbonUI)
On Error Resume Next
    Set MyRibbon = ribbon
    '--read previously saved value of toggle
    gbProtectionState = ActiveWorkbook.ActiveSheet.ProtectContents
End Sub

'Callback for TbtnToggleProtection onAction
Sub TbtnToggleProtectionIsClicked(control As IRibbonControl, pressed As Boolean)
    'call procedure to protect/unprotect sheet
    Call doProtectSheet
    'load sheet Protection status to global variable
    Call ChangeProtectionState
End Sub

'Get Protection state of current sheet
Private Sub 

Open in new window

I have a data source for a mail merge to pull from. Some of the people I have in the data source have an additional name on their account and some don't. When doing their address for mailing, I did figure out how to not display the additional name if it's blank but now I have another question. On the greeting line, I'd like it to say "Dear <Name> and <Additional Name>:" but only include the 'and <Additional Name>' if it contains something. How can I do that? I'm using Word 2016.

I have a powerpoint deck with 50 slides. All slides have the same template, and consists of textboxes containing various pieces of information, like a form.

How can I extract all that information into an Excel spreadsheet, one row representing one slide, and one column representing one text box?
We are facing one issue with a new Lenovo T470s laptop. it is preloaded with windows 10 Pro version:1709 OS Build 16299.309
This PC has default MS office which we need to uninstall we intend installing Office 2016.everytime we uninstall the default MS office it rolls back and asks for an office 365 activation key ,even after having Office 2016 activated
Free Tool: IP Lookup
LVL 12
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Hi Experts,
Our office moved to a new location and suddenly one of my pc's does not want to connect to SQL.
When I try to reconfigure the same DSN, I get the attached error.
Mysteriously, this is only happening to one pc.
Also I'm able to browse the server from that pc thru win explorer.
Any Idea?
FYI- I'm using SQL server login to connect.
Both Exchange 2010 and Office365 Back end. Outlook 2016 Mail Client.

I'd like to Send A Specific Out Off Office Message based on the To: Address that the email address was sent to you.

Mailbox User: gets a Default Out Of Office Message

Distribution List: gets a separate Out Of Office Message and NOT the default message above.

Its a little complicated, though is the only user in the Distribution List We do this so the user can send emails as

When I setup Out Of Office in Outlook 2016 I set it to send to both internal and external. Then set the default message. I then setup a rule where the 'Sent To..." is the Distribution List. the Actions I've tried are Both Forward and Reply with Template. Each time I send my account an email to I get the Message in the Inbox, though I never get the Out Of Office Reply.   If I send to I get the Default Out of Office reply.

I've tried from Internal User, Yahoo and Gmail. All with the same results.

Can you not have a Rule based on the To: address where you are a member of a group that the mail is sent to?
Hello all!
I am going to be uploading information into our system but am trying to avoid uploading multiple instances if the information is the same. Here is an example of the table:

A              B              C     D     E                                                     G
2002      2003      ART 101      INTRODUCTION TO ART             3
2003      2004      ART 101      INTRODUCTION TO ART             3
2004      2005      ART 101      ART CLASS 1                                 3
2005      2006      ART 101      ART APPRECIATION                     2
2006      2007      ART 101      ART APPRECIATION                     2

So basically want to say:
2002 - 2004          ART 101  INTRODUCTION TO ART             3
2004 - 2005          ART 101  ART CLASS 1                                  3
2005 - 2007          ART 101  ART APPRECIATION                      2

Thoughts on how I can do this?

I’m currently testing Azure MFA server, I have applied MFA to my user using a security group when I test I get this error,
I'm not sure why any suggestions?

For security reasons, we require additional information to verify your account
An error occurred
An error occurred. Contact your administrator for more information.
Relying party: Microsoft Office 365 Identity Platform
Error time: Mon, 19 Mar 2018 20:59:50 GMT
Cookie: enabled
User agent string: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:59.0) Gecko/20100101 Firefox/59.0

And this in the event log

Encountered error during federation passive request.
Additional Data
Protocol Name:
Relying Party:
Exception details:
Microsoft.IdentityServer.RequestFailedException: No strong authentication method found for the request from urn:federation:MicrosoftOnline.
at Microsoft.IdentityServer.Web.PassiveProtocolListener.CheckAuthenticationOptionsForMethods(ProtocolContext context, List`1 authMethods)
at Microsoft.IdentityServer.Web.PassiveProtocolListener.OnGetContext(WrappedHttpListenerContext context)

Current Server Setup
2x WAP in DMZ (Server 2016)
2X ADFS (Server 2016)
2x MFA (Server 2016)

So my company is migrating to Office 365 from exchange server (2008 and 2010). I was given the task of exporting everyone's email to a pst file using a powershell script which I successfully completed, but now I have to do the same for their personal calendars as well as the "deltas". I'd like to know if this is possible using powershell as well.
We are trying to clone a client's machine that has Quickbooks and Quickbooks Point of Sale 2013. We are cloning from a old 80GB Seagate SATA drive to a NEW Crucial 250GB SSD using Acronis True image. The clone "successfully" finishes and we can boot the system with the SSD. The issue arises when we open MS Office or Quickbooks and it asks for a re-activation. Normally not a problem but  it alarms the customer who would like to do this to another machine that has had the HDD replaced many times (long story). In addition the original 100GB drive also ask for activation and can not find the POS files after the clone is done. This also happens on the SSD, but we believe that it is linked to what is causing the activation issue. Again, this aggravates the customer as we assured that the original drive will be untouched ( and it was ) but can not find any reason for this. we have resolved the POS issue.

My question is: Is there any absolute way that this can be done that not cause re-activation, or makes sure that the drive is a 100% true copy of the original?

Microsoft Office





Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.