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

Microsoft Publisher has several tools in the Arrange area of the toolbar that are disabled. In particular, the one that I want to use is Group and Ungroup.
publisher.jpg
0
Acronis Global Cyber Summit 2019 in Miami
 Acronis Global Cyber Summit 2019 in Miami

The Acronis Global Cyber Summit 2019 will be held at the Fontainebleau Miami Beach Resort on October 13–16, 2019, and it promises to be the must-attend event for IT infrastructure managers, CIOs, service providers, value-added resellers, ISVs, and developers.

Can you please look at column Q and let me know why I'm getting FALSE.  I either want "research" or blank in the results
Multiple-Pernr-List--EE--4_2_2019.xlsx
0
Hi i have a spreadsheet with many ip addresses and id like to assign a site to the for example

i have 10.11.12.13 and would like to assign a site name of London.
in addition i have 10.11.13.14 and would like to assign a name of Seattle.

I have approximately 50 IP's and around 10000 entries and would like to show the name of the site in one column.

What would be the best approach.

Thanks
0
I am attaching the  conditional formatted file

I need the following help to create a keno table.  The questions are in sheet B.        manual-entered-Conditional-formatti.xlsx

1)  Autopopulate 1st March to 31st March ( how to do it ? does not work with fill handle)

2)  There should be four rows between 1st March,2nd March, etc

3)  There are 20 numbers drawn in each keno draw,
      Whenever  a monitored number gets drawn , it should get coloured in the table 1 to 20

4) Each number should have its own colour , for example no 9 could be green

5) If coloured bar chart could be added to the table to show  the date and number frequency



manual-entered-Conditional-formatti.xlsx
0
Hello experts,

I am looking for the best way to built 3 procedures:

1-Display last used column letter in activesheet
2-Display last used row number in activesheet
3-Display initial Range and end range of activesheet example: A1:C4000

Thank you very much for your help.
0
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
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
Python 3 Fundamentals
LVL 13
Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

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
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
CEOs need to know what they should worry about
CEOs need to know what they should worry about

Nearly every week during the past few years has featured a headline about the latest data breach, malware attack, ransomware demand, or unrecoverable corporate data loss. Those stories are frequently followed by news that the CEOs at those companies were forced to resign.

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

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.