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

Merge 2 Excel 2016 Files to single file and group records

I have 2 files, each with 4 columns:

Email Address - First Name - Last Name - Type

My goal is to merge these files so that records with same Last Name values will be grouped in the new file, that is the records will be grouped - sorting of fields not necessary.

How do I do this?
0
Get expert help—faster!
LVL 12
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Hi,

Is there one example in SharePoint list that one date change would trigger one defined alert automatically? For instance, I put deadline column to beJuly18, and after two days, alert message would be automatically sent out.
0
In the given sample in sheet-1 there is a column called skill where filter is applied.
What I need to do is apply filter for each skillset and then count the frequency of numbers under the column baseline level and then place the frequency of each number into sheet-2 under L1,L2,L3 of the current level.
for eg-
in sheet 1 filter the skills column by lets say, the skill "Angular JS".
Therefore, now the baseline level column contains only entries i.e 0 and 1. So count the occurences of 0s and then in Sheet-2 look for the row with the entry Angular JS. After that fill L1 (current level) with 1 (as 0 only occurred once) and L2 with 1(as 1 has occurred only once).
finaltask.xlsx
0
Hi All,
I'm working with an MS Word template using fields linked back to another system.  The text in the fields are a variety of color codings.  I'm trying to create a macro that, On Open, will set all of the text to black.  Can anyone help me?  Thank you!
0
I used to use a software called QueryCell.  It allowed you to easily take columns from excel and easily create update and insert statements.  Unfortunately this doesn't work with current versions of excel.  Can anyone tell me if they know of something similar?

Thanks


 Screenshot of QueryCell
0
I have the following code which is working perfectly:

Public Sub MakeThisConfidential()
Application.ActiveInspector.CurrentItem.Sensitivity = olConfidential
Application.ActiveInspector.CurrentItem.Save
' MyMsg = MsgBox(Prompt, 0, "This message has been marked Confidential and will be encrypted by Fusemail")
MyMsg = MsgBox("Click OK to accept status" & vbCrLf & "This will encrypt the Current Message using fusemail", 0, "This message has been marked Confidential")
End Sub

Sub ToggleSensitivity()
    If ActiveInspector.CurrentItem.Sensitivity = olConfidential Then
        ActiveInspector.CurrentItem.Sensitivity = olNormal
        MyMsg = MsgBox("Click OK to accept status" & vbCrLf & "This will NOT encrypt the Current Message using fusemail", 0, "This message has been marked Normal")
    Else
        ActiveInspector.CurrentItem.Sensitivity = olConfidential
        MyMsg = MsgBox("Click OK to accept status" & vbCrLf & "This will encrypt the Current Message using fusemail", 0, "This message has been marked as Confidential")
    End If
End Sub

Open in new window


I have attached it to 2 separate buttons
I want to be able to run the macros and change the current button image. The image is added by the outlook interface:
In the New Mail window:
File - Options - Customise Ribbon - Main Tabs - New Mail Message
There is a group in here which has buttons with the macro's attached
0
How to create a Concatenateif with multiple criteria (and/or options for multiple criteria) in excel?  A simple example of desired outcome is in the attached spreadsheet.
concatenate-example.xlsm
0
Does anyone know how to save a file name from another cell value in another excel workbook?  I plan to do this process several times too.  I have two files that I am working on.  The first is named "Entry File", and another file named, "FY 19 MCT Final".  I want to know how I can take the value of cell B1 in the "Entry File" and have it be the new name for "FY 19 MCT Final".
0
Dear @Shums,
This is additional requirement for my previous question (https://www.experts-exchange.com/questions/29107816/VBA-for-inserting-and-deletion-of-new-columns.html) which you helped me.

REquirement : For all the weeks which we insert, the total column should have the sum of the values below it.

For e.g. IF we insert 2 weeks , then if the value of Week1 is 2 and Week2 is 1 then the sum should be 3.

Similarly, if we insert 3 weeks, then if the value of Week1 is 2 , Week2 is 3 and Week3 is 1 then the sum should be 6.

The sum formula should not get changed once we change the number of weeks.

I have attached the scenarios in sheet 2.
KailashKapal_InsertColumns_v3.xlsm..xlsm
0
I have 5 users on logging into the server using remote desktop connection and I need to know what version of office works, when I call Microsoft they say I need one license for every device accessing the RDS but it doesn’t make any sense to me, I access my remote session from my iPhone, home computer, laptop and iPad can anyone direct me in the correct direction without having to break bank in the process?
0
Cloud Class® Course: Certified Penetration Testing
LVL 12
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

Excel convert time and date from UTC to EST/EDT (depending on the time of the year)
2017      March 12th 2am      Clocks moved forward 1 hour
      Nov 5th 2am      Clocks moved back 1 hour
            
2018      March 11th 2am      Clocks moved forward 1 hour
      Nov 4th 2am      Clocks moved back 1 hour



This is the current format in the cell; 2017-02-09 14:25:04 UTC
0
ImageHello Experts,

I have an Article Content Type that I'd like to display all of the Articles, on separate pages based on a Choice Field Item.  Any help on how I can achieve this is very much appreciative.
Using SharePoint 2013 On-Prem.  I don't need help on creating the content type, only on how to get them to display on their own pages that are page-able.  To also include the Title, an image, and part of the Body.
 
0
Hi - I've been asked by a friend to assist them with an issue. They were having problems with Windows 10 and contacted a company who appears to have 'Reset' the PC within the Windows 10 recovery settings. At first glance, it seemed that all the installed applications and locally held data (word docs, photo's etc) had been removed. I'm sure you will not be surprised to hear that there is no backup. However, a copy of the user profile (including data) has been located within the 'windows.old' folder. This is great news for my friend. The issue that I would like assistance with is as follows:

1) They were using Windows Live Mail to access\download their email. This data appears under C:\Windows.old\Users\yourlogonname\AppData\Local\Microsoft\Windows Live Mail.
a) I'm struggling to download a genuine copy of Windows Live Mail - Is it still possible to download from a reputable source?
b) If I can download and install, how do I recover the data into the recently installed Windows Live Mail application?
c) If it's not possible to download, can the old data be imported into another program to view the email? If this is possible, how do I do it?
d) Friend does not remember email password. Original email provider has been taken over a number of times and current provider is unable to verify security requirement to reset password. Is there a tool to recover a password stored in Windows Live Mail that is no longer installed but records exist under windows.old ?

2) Friend is …
0
I need a excel macro to get comment "ACTIVE", "DELETE" in "F" column. Column "E" is the sum of "BCD"
0
I have a large cash forecasting model with weekly data in each column.  Each column has numerous index/match formulas that look up values from other sheets in the workbook.  Each column concludes with ending cash and the next column begins with with that ending cash from the previous week.  

For example, B1 = A20, C1 = B20 and this format continues outward for 75 weeks or until the end of 2019.  So, there are literally thousands of index/match formulas and a few hundred circular references in this model.

Everything works fine until you reach ~30 columns and then the numbers start to drift.  For example, assume AC20 = 100, therefore AD1 should = 100 also.  But it doesn't, It displays 98.  However, if you press F2 and then F9 the answer will be 100.  It's the strangest phenomenon I've ever seen in Excel.  

Oddly the error pattern seems to run in a sine wave fashion.  The first column will be off -2 as in then example above and then the next column is off +4 and then -8 and then +16, etc.  This same pattern continues through the last column and the variances get very large.

I have tried numerous combinations of formula iteration tweaks in Excel Options, I have tried "precision as displayed" and I have tried rounding the formulas in the target cell and the destination cells of the index/match formulas.  Nothing seems to make a difference.

Does anyone have any idea what could be causing this error to occur in Excel?  I've never see anything like this before.
0
I have a vertical list. See attached file. What formula would I need to use so that the entries are captured horizontally. For example in D5 I have 1/1/2018, in cell G5 I have 1/1/2018. What do I need to use so that if I change the entries in D5 to D20, they automatically update in cells G5 to V5. It's in Sheet 2 of this file.
EE_Date_Sequencev2.xlsx
0
I have a column of dates, of which I need 2 formulas ... one for the maximum consecutive days listed, and the other for the current consecutive days.

Example spreadsheet attached. Thanks!
Consecutive.xlsx
0
I created a windows forms application using visual studio 2015.  My app connects to a SQLSERVER (SQLEXPRESS).
I Publish the app by creating a shortcut to the release bin directory on a network drive.  All was working well but recently I started
getting the following error on some computers.

 A network-related or instance-specific error occurred while establishing a connection to SQL Server.
The Server was not found or was not accessible. Verify that the instance name is correct and  tat SQL Server is configured to allow remote connections.
(provider: TCP Provider, error: 0 - An invalid argument was supplied.)

I use a static connection string, and it is working on some computers.  I Published the app to a network drive, and it ran ok.  I am not sure what the publishing does,
but I would rather just run it from the bin directory.
0
Hi,

Anyone can advice still can't retrieve user software & inventory report even though the agent is pushed down with status of client is installed and activity client is active.

See attached screenshot.
noreport.jpg
0
Cloud Class® Course: Microsoft Exchange Server
LVL 12
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

Hi Anyone,

Can I anyone advice how to troubleshoot this error as attached for your kind.

1. Is able to ping and SCCM can detect client and is active.
2. When tried to \\LIOE17BSD1889LC\admin$ => I've the local admin password but just can't connect when trying to use domain\admin, .\admin or \admin still can't  

Trying to go client action > Run Software Inventory Cycle and got this error.

Ps advice.

Tks.

Lucky
error-permission-denied-70.jpg
0
SSRS Report Builder - Export to CSV issue; Double Quotes exist for each record.

We have a report that is scheduled to produce a CSV file.
This file is consumed by another application and requires specific formatting in order to successfully process the file.
The following entry has been configured within the 'rsreportserver.config' file:

<Extension Name="CSV (No Header)" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering">
                        <OverrideNames>
                              <Name Language="en-AU"> CSV No Header</Name>
                        </OverrideNames>
                        <Configuration>
                              <DeviceInfo>
                                    <NoHeader>true</NoHeader>
                                    <Extension>CSV</Extension>
                                    <Encoding>UTF-8</Encoding>
                                    <Qualifier></Qualifier>
                              </DeviceInfo>
                        </Configuration>
                  </Extension>

The file that is being generated from this contains double quotes at the start and end of each record (see below).
"""FORMAT BATCH IMPORT, STANDARD 1.0"""
"DREF1,DDATE1,DSOURCE,DCLRENTITY,DENTITYPE,LLDGCODE,LACCNBR,LAMOUNT1,LNARR1,LNARR2,LNARR3,LPRESCSTAT,LGSTTYPE,LGSTRATECODE,BIMPNAME,BCLRENTITY"
"180603,06/06/2018,AB,123,A,AB,123456789,-1234.56,Team Journal,21/05/2018 to 03/06/2018,12345,N,I,NA,TEAMJNL,123"

The output we need is shown below:
"""FORMAT BATCH IMPORT, STANDARD 1.0"""
DREF1,DDATE1,DSOURCE,DCLRENTITY,DENTITYPE,LLDGCODE,LACCNBR,LAMOUNT1,LNARR1,LNARR2,LNARR3,LPRESCSTAT,LGSTTYPE,LGSTRATECODE,BIMPNAME,BCLRENTITY
0
Hello all,

So I've been tasked with exporting all partner's contact lists to CSV so we can compile them all together for a master list. We're using O365 and I was hoping I don't have to go to each partner machine (over 20) to run the export contacts wizard in Outlook. Is there a script that can perform this task or can it be done from Admin Center? Thanks in advance.
0
Using Access 2016:  I have a Query which groups agents by sales. Not every one will have data that month. I would like to email each individual agent his sales for that month. My questions are:
1. what's the best way to set this up, IE should I use a query, or a report based upon the query. I would need to create an agents table with email and name.
2. what are the steps involved?
3. what would be the code, we currently use go daddy for our email. We do not have a server in-house.
4, what event of the report or query would I use to add the code?
5. can you share code that works for 2016 access?

is this even possible? If the agent has no sales for that month, it should not create the email or should not create a report, if the report is based on a query?
If you can help, I would be gratefully appreciative, or if you can point me to a "dummies" link where I can try to create something.

The last question I had, I got some awesome answers from PatHartman and John . I am in hopes that one of the experts can help me with this as well as those two helped me with my query question. I know this is a lot to ask, but if you know, please help.
0
Y = cleanup
N = never cleanup

i've 10,000 user exchange mailbox after compared so did and some didn't cleanup.

e.g  

Give Y when mailbox size is below 500MB that is good when user perform housekeeping by themselves
Give N when mailbox size is above or equal 500MB that tell user didn't perform housekeeping

How to compare in excel to output either Y or N.

Thanks
0
I am interested in trying to use PowerShell against our company SharePoint portal, We have some automation Tools like MS Flow and Alteryx Server that we are leveraging and I am trying to connect to a Workflow History listing. However, it is hidden from these other tools and I hoping Powershell might be an option.

I am trying to install and get it to work our on AWS EC2 environment and I keep having a lot of trouble adding the Add-In for SharePoint,

I tried following this kind of instruction but had zero success.
https://blogs.msdn.microsoft.com/opal/2010/03/07/sharepoint-2010-with-windows-powershell-remoting-step-by-step/

We are SharePoint Online/O365

Any suggestions?

Regards,

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