Microsoft Applications

44K

Solutions

38K

Contributors

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

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

Sign up to Post

Hi,

I can't find the Microsoft Office folder under Programs (x86).  Any ideas why this is missing?  I'm able to use the Microsoft applications just fine but in order to install a vendor add-in correctly, they said this folder needs to be present.
0
CompTIA Cloud+
LVL 13
CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

Hi Experts

https://testconnectivity.microsoft.com

does not work do we have any alternative to test

skype for business

exchange

etc

thanks
0
hello SCCM guru's!

We are upgrading to SCCM 2012 R2 1810. However, the pre-req check fails on here: [Failed]:No Active MP Replica detected. (We do not even have a MP replica.)

All else passes. But it will not allow upgrade without resolving that error.

Any ideas on how to get past that?

Thank you for your assistance!

-Mack
0
Excel -  Is there a way to filter for STRIKE THROUGH text??
0
I have Sheet A.csv and Sheet B.csv. Both have a column called 'Transaction ID'. I want to go through all rows in Sheet A and check the value in the Transaction ID column. If this value matches any value anywhere in the 'Transaction ID' column of Sheet B, I want the row deleted from Sheet A. And to carry on doing this for every row in Sheet A, so that in the end, none of the Transaction IDs in Sheet A will match those in Sheet B.

Do you know how to do this? Would if be a macro? Or better still, is there a way natively within Excel?

Thanks.
0
Hello experts,

I have the following xls file.
I am looking for a procedure or a efficient way to properly set up page view breaks in order to print the various pages.
The idea will to set up a procedure in order to:
1-Read from Initial column to last column and set up page break.
2-Have the same number of rows by page.
3-Properly adjust column & height width in order to get the most the page

I want to avoid to do this manually and I suppose it should be a way of doing this through a procedure.

Thank you in advance for your help.
Data-page-set-up.xlsx
0
Hello experts,
I have the following procedure reported at:
https://www.experts-exchange.com/questions/29136207which uses 3 inputbox to perform an specific action (Dummy file attached).
Sub Improved_Index_Match()
Dim SrcWs As Worksheet, TrgtWs As Worksheet
Dim IndexRng As Range, MatchRng As Range, MatchValue As Range, MatchValRng As Range
Dim iRow As Long, mRow As Long, iiRow As Long, mmRow As Long, iCol As Long, mCol As Long, mvRow As Long, mvCol As Long, mvvRow As Long

On Error Resume Next
Set IndexRng = Application.InputBox(Prompt:="Please select INDEX RANGE, range that you want to lookup in your Source range: ", Title:="Index Range Select", Type:=8)
On Error GoTo 0
If IndexRng Is Nothing Then
    MsgBox "You didn't select any cell in the Index Range.", vbExclamation
    Exit Sub
End If
    
Set SrcWs = IndexRng.Parent
iCol = IndexRng.Column
If SrcWs.Cells(1, iCol).Value <> "" Then
    iRow = 1
Else
    iRow = SrcWs.Cells(1, iCol).End(xlDown).Row
End If
iiRow = SrcWs.Cells(Rows.Count, iCol).End(xlUp).Row
Set IndexRng = SrcWs.Range(SrcWs.Cells(iRow + 1, iCol), SrcWs.Cells(iiRow, iCol))

On Error Resume Next
Set MatchRng = Application.InputBox(Prompt:="Please Select MATCH RANGE which is located in the same sheet of your Source range", Title:="Match Range Select", Type:=8)
On Error GoTo 0
If MatchRng Is Nothing Then
    MsgBox "You didn't select any cell in the Match Range to compare with.", 

Open in new window

0
What are the steps to enable Phased Deployments within SCCM 1810?
0
Hello experts,

I have the following procedure which allows me to perform index match based on range selection.

Sub Index_Match()

Dim lCol As Long
Dim matchvalue As Range
Dim n1, n2, n3 As Long

On Error GoTo exit_sub

MsgBox ("WARNING: In order to properly run this procedure Check that:" & vbNewLine & _
"1-Select the initial range that is going to receive the index range" & vbNewLine & _
"2-Three ranges should have the same initial range")


Set target = Application.InputBox(prompt:="Select index range, range that you want to lookup in your output range: ", Title:="Range Select", Type:=8)
n1 = target.Parent.UsedRange.Row + target.Parent.UsedRange.Rows.Count - 1
MsgBox (n1)
Set target = Range(target.Cells(1, 1), target.EntireColumn.Cells(n1, 1))

Set matchvalue = Application.InputBox(prompt:="Select match range which is located in the same sheet of your output range", Title:="Range Select", Type:=8)
n2 = matchvalue.Parent.UsedRange.Row + matchvalue.Parent.UsedRange.Rows.Count - 1
MsgBox (n2)
Set matchvalue = Range(matchvalue.Cells(1, 1), matchvalue.EntireColumn.Cells(n2, 1))

Set comparedvalue = Application.InputBox(prompt:="Select compared range, this range is located in the same sheet of your index range", Title:="Range Select", Type:=8)
n3 = comparedvalue.Parent.UsedRange.Row + comparedvalue.Parent.Rows.Count - 1
MsgBox (n3)
Set comparedvalue = Range(comparedvalue.Cells(1, 1), comparedvalue.EntireColumn.Cells(n3, 1))
lCol = ActiveCell.Column - 

Open in new window

0
Excel - I am working with a start date and Intervals based on hours.

I need to be able to identify the next due date for a list of items.

Example:
Those that should happen weekly, every 2 weeks, monthly, yearly, quarterly, etc.

I can't figure out how to change the next due without changing the original start date.

Please see attached file.
DueDates2.xlsx
0
Get a highly available system for cyber protection
Get a highly available system for cyber protection

The Acronis SDI Appliance is a new plug-n-play solution with pre-configured Acronis Software-Defined Infrastructure software that gives service providers and enterprises ready access to a fault-tolerant system, which combines universal storage and high-performance virtualization.

I'm looking for the steps for using SCCM 2016 to deploy the Server 2019 and 2016 operating systems to VMware and Hyper-V virtual machines.
0
What are the best books for learning Microsoft System Center Configuration Manager (SCCM) 2016?

I need to learn how to use SCCM 2016 to:

- Approve and install Windows updates on Windows Servers and Windows 10 computers

- Install applications such as Microsoft Office, WinZip, Acrobat, Adobe Flash, Google Chrome, etc. on remote computers

- Deploy Server 2016 and Server 2019 within VMware and Hyper-V virtual machines

- Deploy Windows 10 on computers using PXIE boot

- Perform upgrades from Windows 7, Windows 8, and Windows 8.1 to Windows 10 on existing computers leaving all of the existing applications and settings intact

I am only interested in books that describe and have step-by-step exercises on how to do this for SCCM 2016.

I am hoping to find a book that describes these things exactly as they need to be done so that while I am on the job I will be able to refer to this book for the steps on how to do these things.
2
Unwanted line breaks in outlook 2016.
getting unwanted line breaks when sending email in outlook 2016 on windows 10, 1803.

so when he sends an email, it breaks the sentence to go to the next line but
he doesn't want that to happen.

Any ideas on how to fix this?

tried removing and recreating outlook profile after delteing the .ost file.

tried going to File/Options/Mail, under Compose
messages changed HTML to Rich Text and Plain Text but it did not work
either.

tried
File > Options > and scroll down to "Advanced" on the left. Change the
dropdown for "Automatically select encoding for outgoing messages" from
Western European (ISO) to Unicode (UTF-8).

tried
On the File tab, click Options.
In the Options dialog, click Mail.
In the Message format section, clear the Remove extra line breaks in plain
text messages check box.
Click OK.
0
If my iCloud for Windows is being installed by Apple Software Update, may I know which bit version of iCloud is installed? 32 or 64 bit? Where can I check this information?
1
Need to setup a display outside the boardroom to show the room booking info.
We have an in-house Exchange Server 2010, on which there is an account "Boardroom" whose calendar is being shared in the company.
We are seeking a solution that is able to display "Boardroom" calendar outside the boardroom.
Any thoughts?
Thanks
1
I am trying to customize a print dialog in a MFC app.
I want the "pages" option to be preselected.

In CMyView::OnPreparePrinting(CPrintInfo* pInfo)
I added this at the end of the function:
      pInfo->SetMinPage(10);
      pInfo->SetMaxPage(20);
      pInfo->m_pPD->m_pd.nFromPage = 10;
      pInfo->m_pPD->m_pd.nToPage = 20;
      pInfo->m_pPD->m_nFlags |= PD_PAGENUMS;
      return DoPreparePrinting(pInfo);

When the print dialog comes up, the "all" option is preselected.
0
I'm looking for a couple of MSN updates I'm not sure what the KB's are just the version numbers of the product.  The Product is Visual Studio 2012
Currently loaded Visual Studio 2012 Version 11.0.61030.0  Fixed version 11.0.61232.400.  I cant find the update that'll get it that particular version.  I've installed update 5, & kb4089501.
0
Hi

We are looking at upgrading our core MS applications and OS and the licencing seems to differ from distributor to distributor.
Can someone help clarify the following:

  • Exchange Server - we are hybrid exchange 2010 with ALL mailboxes in 365.  Do we need to licence exchange 2019 or 2016 or do MS offer a free key still?
  • Exchange cals - as above - i'm assuming the exchange online plan 1 covers the cals for users/devices?
  • Windows server cals - we have bought 60 windows 10 licences - one supplier says we dont need cals, the other two say we do..?
  • SQL server - we will be using two standalone SQL servers, of which one is production servicing live clients and data, the other SQ lserver is online but for DR/BC usage only.  Do we need two server licences or one?

Thanks
0
Hi Team, Need 2 help with my excel file.

1. I have attached 2 file. Daily report should update on  as per date in utilization sheet.xlsm. See the attached Daily Report file where i have use macro record option.

Need: I need that once date get change from 07-Jan-19 to 08-Jan-19 in (E7: Daily report.xls) so update button should take data from next column (G8, G21).

2. Once we are taking the screenshot its taking TAB name in 1st row, instead of tab name, i need that it should  take (E8) "Daily Work hour report for 07-Jan-19" text.

Thanks
Utilisations.xlsm
Daily-Report.xlsm
0
Exploring SharePoint 2016
LVL 13
Exploring SharePoint 2016

Explore SharePoint 2016, the web-based, collaborative platform that integrates with Microsoft Office to provide intranets, secure document management, and collaboration so you can develop your online and offline capabilities.

Wanted to count values based on certain criteria.   For example per the attachment.

The count is on the "MAT_REC_BY_MONTH" tab and the data is on the "DATA" Tab.  I've added some values on Week 1 and week 2 to show what the values should be.

On "MAT_REC_BY_MONTH" tab:  Column D (REC), the count is based on the "DATA" Tab Column Z filtered on "blanks" on Column AB for Calendar WK 1 on column Y.
On "MAT_REC_BY_MONTH" tab:  Column E (REJ), the count is based on the "DATA" Tab Column Z filtered on "YES" on Column AB for Calendar WK 1 on column Y.

Wanted a formula to count for all the weeks listed on the "MAT_REC_BY_MONTH" tab.  See attachment.
C--Users-lfreund-Downloads-COUNT-EE.xlsx
0
Hello experts,

I have the procedure reporting at the end of my message that I use from my personal.xlsb in order to compare values from different columns.
I would like to enhance the procedure by modifying the following:
1.      Instead of selecting the various range from top to down I would like to enter the column letter and the procedure should be able to display the range from initial top range till the last of used range and display input box “Range involved is equal to :”. This process should be applied for both columns
2.      Finish the procedure with the procedure by a filtering cells based on Interior.ColorIndex = "3"
3.      Display a Msgbox if the user cancels the procedure in of the range selection.
If you have questions, please contact me
Sub Is_Na()

Application.DisplayAlerts = False

Dim c As Range
On Error GoTo exit_routine_isna
Set UsedRange = Application.InputBox(prompt:="Please Select your range source, in this range you will find the cells wich are not in your range to compare", Title:="Range Select", Type:=8)
Set ComparisonRange = Application.InputBox(prompt:="Please Select Range to compare", Title:="Range Select", Type:=8)


For Each c In UsedRange
If IsNumeric(Application.Match(c, ComparisonRange, 0)) Then
Else: c.EntireRow.
End If
Next c Interior.ColorIndex = "3"
exit_routine_isna:
End Sub

Open in new window

0
Hi Expert,
I have given anonymous access for one of my SharePoint site. In that site I have some documents but I don't want allow anonymous users to open it.

Please help

Thanks

Zahid
0
I need to insert after every single raw the value from the third column like the sheet1 attached.

Regards,

Dallag
insert_every_sngle_raw.xlsx
0
I have a list of documents in an excel file and want to use this list to move specific PDF files from one folder to another. Is there a script that can be produced in Excel VBA to assist in this task. Also, can the script be made so it can be used for any type of document transfer?

An example of the script requirements would be

A POP-up box would appear requesting the list range
A POP-up box would appear requesting the location of files to be transferred
A POP-up box would appear requesting destination of the files to be moved
0
I am having trouble getting the BlockDownloadOfAllFilesForGuests setting set for my Sharepoint/Onedrive account.  The feature is detailed here: https://social.technet.microsoft.com/wiki/contents/articles/39497.onedrive-for-business-sharing-settings-with-powershell.aspx?Redirected=true#Block_Download

I am using Sharepoint Online Management Shell version 16.0.8316.0.

I have downloaded and installed the latest COM  from here: https://www.microsoft.com/en-us/download/details.aspx?id=42038   
using file sharepointclientcomponents_16-6906-1200_x64-en-us.msi

After downloading the script from this page, https://gallery.technet.microsoft.com/office/Block-of-all-files-for-2ad7a0db, and following its instructions I am getting the error below:

Exception calling "ExecuteQuery" with "0" argument(s): "Updating this tenant property is currently disabled."
At C:\BlockDownloadOfAllFilesForGuests.ps1:25 char:3
+   $ctx.ExecuteQuery()
+   ~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (:) [], MethodInvocationException
    + FullyQualifiedErrorId : ServerException

Any help would be greatly appreciated.
0

Microsoft Applications

44K

Solutions

38K

Contributors

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.