[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x

Microsoft Office

66K

Solutions

41K

Contributors

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

What formula do I need to find the Key in column B that has specific values in column A.

Example:
ColumnA      ColumnB
200.              100
300.              20
400.              30
50.                20
600.              20

Find value in column B that has 600, 50 and 300 in column A. Answer = 20.
0
Determine the Perfect Price for Your IT Services
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

In the Office 365 Exchange admin portal I am forwarding several users' mail to an outside address, which are mail contacts? Is it possible to also set up Out Of Office (Auto Reply) Messages for the users?  It looks like if I forward without delivering to the mailbox as well, the auto reply is not sent.  Thanks.
1
What VBA do I need that will look at two strings and show a message box stating which is larger?

Example:
1) String1 = "1-668!a"       String2 = "1-668!b"
2) String1 = "288$4$22"  String2 = "287$4$22"
3) String1 = "100(4)(57)" String2 = "100(4)(577)"

1) String 2 is larger
2) String 1 is larger
3) String 2 is larger

By larger I mean which will be listed last if sorted in  ascending order.
1
I asked this question before, and after cleaning up the system in question, thought I had stumbled across the solution.  No luck

Office 2013, Win 7 Pro, 2008 Server SMB  simple File Shares (one user), Symantec Enterprise Edition

Word and Excel Files occasionally take FOREVER to open (minutes, not seconds)

PDF files never have this issue.  

these account for the vast bulk (99%) of the file types this user accesses.
0
I had this question after viewing Office 365 Hybrid Exchange - Mailbox provisioning.

The link in this solution has expired.

I would like to:
Local AD:  Create user and sync to Office 365 cloud.
Office 365: Apply appropriate license that includes Exchange email.

Problem and possible reasons: Account created but Exchange mailbox not provisioning.  This used to be an old SBS server (upgraded to Win2K12 now).  I think it still has old Exchange attributes,  How do you rectify this?
0
Hi guys

I've got an Excel sheet with around 12 columns and around 34 rows of content. I want to be able to do a mail merge, so that the content of 4 out of 12 of these columns and all of the rows can be sent to our ticketing system to create a separate ticket for each row.  

Is there a way to do this?

Thanks for helping
Yash
0
I need to be able to pull everything between the second and third dash in a list of items.

0-AP-LP-6001-CB-MB  >  result = LP
0-AP-MCC-6000           >  result = MCC
0-AP-XFMR-6007         >  result = XFMR
0-FA-5001A-B-6           >  result = 5001A
0
I would like to create a folder in my OneDrive that is shared between 5 staff members. I will use this folder to add office templates etc. All users have one drive installed and syncing as well as Microsoft Office 365 Business Premium setup. Is there a way I can create this folder on my end as the administrator and add the files and proceed to share the folder with the specific users. Then when they are next online it will just sync the folders and files to their machines via OneDrive? I know with Dropbox you just share the folder and click on the hyperlink in the email but with OneDrive it does not work this way and the users can only view the shared files via the web portal which they never use. I am trying to avoid having to do all the steps manually for every user every time a shared folder is added as they are not technically proficient at all.
0
We have a client who is using Sharepoint instead of Network drives.

They have a shared spreadsheet which is an xlsx that they all have write access to so have the correct permissions for Co-Authoring. This sheet is used multiple times a day with multiple people editing.

The users are getting an 'unable to save due to others being in spreadsheet' bar appear nearly everytime they are in it. They then have to close the spreadsheet & reenter any data that was input.

I have already resaved the spreadsheet to xlsx to give them co-authoring. Am I missing something else that would be causing this issue?
0
I once uploaded an MSWord file in EE & one expert commented he could
see my name, the company I worked for & even the previous person who
edited the file was identified.

Was told in MS Office there's this metadata.  Where/how can I check for
this metadata & how can we securely remove it?   I'm using MS Ofc
2000 & 2016

Does PDF files also have such metadata?
0
Learn SQL Server Core 2016
LVL 12
Learn SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

i am getting this pop up when I installed office 2016 . ( attached)

any reason why myself and other users are seeing
Capture15.PNG
0
In Office 365, where can I go to find out what files are shared with users external to my company from either sharepoint sites or from users one drive.
0
i am suppose to create a calendar to be shared with whole company

since we have mailboxes in office 365 and no on premise exchange server, only on premise Active directory for which AD user objects are synced through AAD sync to Azure AD.

So i created shared mailbox in office 365 and tried to gain access to that mailbox and shared calendar through OWA to few users.

i see that shared calendar showing in users outlook but it is not showing in those users directly under MY Calendar option

instead it is showing as under other or shared calendar

is there any way i can put that shared calendar under users my calendar option

i gave full access but it still shows under other calendar
0
Hello experts,

I have the following procedures which allows me to add specific strings in first & last position of a column values.

Sub Add_Specific_Char_First_Position()
Dim rng As Range
Dim strSpecificChar As String
Dim strCol As String
Dim lngLastRow As Long
Dim lngRow As Long

    strCol = InputBox("Please enter the column letter in which you add specific string:", "Choose Column Letter")

    lngLastRow = Range(strCol & Rows.Count).End(xlUp).Row

    Set rng = Application.InputBox("Please select the cell in which you want to add the specific character:", "Select cell", Type:=8)

    If Not rng Is Nothing Then
    
        strSpecificChar = rng
        
        For lngRow = 1 To lngLastRow
            Cells(lngRow, strCol).Value =  strSpecificChar & Cells(lngRow, strCol).Value
        Next

    End If
    
End Sub

Open in new window


Sub Add_Specific_Char_Last_Position()
Dim rng As Range
Dim strSpecificChar As String
Dim strCol As String
Dim lngLastRow As Long
Dim lngRow As Long

    strCol = InputBox("Please enter the column letter in which you add specific string:", "Choose Column Letter")

    lngLastRow = Range(strCol & Rows.Count).End(xlUp).Row

    Set rng = Application.InputBox("Please select the cell in which you want to add the specific character:", "Select cell", Type:=8)

    If Not rng Is Nothing Then
    
        strSpecificChar = rng
        
        For lngRow = 1 To lngLastRow
            Cells(lngRow, strCol).Value = Cells(lngRow, strCol).Value & strSpecificChar
        Next

    End If
    
End Sub

Open in new window



I would like to merge those procedures in one procedure by adding input boxs and if conditions.
1-Inputbox ("Please report column letter in which you want to apply procedure")
2-Inputbox (“Please report value related to the action that you want to perform: 1 for adding string at the beginning else at the end”)
3-Inputbox(“Please select the cell in which is reported value that you want to add”)
Thank you in advance for your help.
0
I’m migrating a client to a new computer, a Dell Latitude 7490, from an older Dell Latitude running Windows 7. She is currently using Microsoft Office 2007 Ultimate.  She has the disks but because the new computer doesn’t have a disk drive it will be a bit of a pain installing it on a new computer.  I’ll upload it to Dropbox and download it to the new one.

We’re wondering whether it would make more sense to just buy a newer version, maybe a subscription version of Microsoft Office. What are the pros and cons of doing so?  She uses Outlook.  Will the migration of her .pst files be easy if she goes to a new version? Will there be any problem migrating her Word and Excel documents?

What are the advantages to going to a newer version? My client is a journalist so she does lots of writing. Microsoft Office seems to get more complex with each version. Often that complexity gets into the way of doing work, rather than being a useful addition. How about the costs of going to a new edition?

Thanks,
Alan
1
Received this after reopening Excel file for another label printing attempt after minor address change to1 record in Excel file

Error! MergeField was not found in header record of data source.

What does in mean? How do I fix this? Data in 2016 Excel for Mac; Label Merge form in 2016 Word for Mac
0
I need an excel formula that will calculate the highlighted price for each year.  The blended price should be the total of the ((maximum number of accounts in the the lower tier number of accounts)  (times) the (price for that tier))  (plus) the (total number of accounts in excess of the lower tier) (times) the (price for the higher tier).  Please see the workbook attached.  Thank you
Account-Pricing.xlsx
0
Hello Experts,

I have a legitimate product key for Microsoft Visio. Can someone let me know where I can find the link to download Microsoft Visio 2016?

Thanks

Carlton
0
Today, while attempting to access my long-standing Hotmail account (bruce.morris4800@hotmail.com), I received a notification that my account had been blocked, allegedly for producing spam. The resolution was to obtain a code (via my cell phone message) to have the account unblocked. I did so, as requested. Regrettably, the result was a new account, with the same name, but with no content, i.e. the over 10 year's worth of data was gone! Please advise what ca be done to resolve this important issue. Appreciatively, Arbyem
0
Big Business Goals? Which KPIs Will Help You
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Hello

Need help with a formulas to calculate:
1. (Cell DM23) Most recent past 6-week run rate of 52 week historical data that excludes zeros and high- low numbers (seasonality/Standard Deviation > X).
2.  (Cell DN24) Return data in Range $BM$22:$DL$3171 in column DN depending on current week written in Cell DM16

(see attached file)
Automate-Run-Rate.xlsx
0
How do I get data from a closed excel file into an outlook VBA collection?

The size of Sheet1 is N-row by M-column and data is sparsely populated.

N is not fixed (changing as rows are added to or deleted from the end of the Sheet1).

I would like to read data (including empty cells) from the entire N x M range.

The total number of collections is M and this number is fixed.

Kindly provide VBA code if possible.

Thank you.
Thomas
0
hi,
old setup - got a mac with pop3 email account
new setup - got a mac with office365 email account
i am migrating a pop3 account to office365, i successfully moved all emails and contacts. i manually copied all items into office365

but how do i migrate pop3 calender to office365 calender ?
i exported from old pop3 account and imported into office365 email. it created "under my computer" and showing the exported calender . but how do i bring it into office365? so i can see it from web portal ??
0
How can I change the below code into a function so that I can just plug in the following information?

Variables to substitute in code
ActiveSheet = Sheet name
PivotTable = Pivot table name
Value = Field name
Columns = Field name
Rows = Field name
Filter = Field name


Sub Rebuild_PivotTable()

    ActiveSheet.PivotTables("PivotTable3").ChangePivotCache ActiveWorkbook. _
        PivotCaches.Create(SourceType:=xlDatabase, SourceData:="Open Raw Data", _
        Version:=6)
        
    'Clear all pivot table fields
    ActiveSheet.PivotTables("PivotTable3").ClearTable
    
    'Add to values field
    ActiveSheet.PivotTables("PivotTable3").AddDataField ActiveSheet.PivotTables( _
        "PivotTable3").PivotFields("Incident ID"), "Count of Incident ID", xlCount
    
    'Add to Columns field
    With ActiveSheet.PivotTables("PivotTable3").PivotFields("Status")
        .Orientation = xlColumnField
        .Position = 1
    End With
    
    'Add to Rows field
    With ActiveSheet.PivotTables("PivotTable3").PivotFields("Site")
        .Orientation = xlRowField
        .Position = 1
    End With
    
    'Add to Filters field
    With ActiveSheet.PivotTables("PivotTable3").PivotFields("On Report")
        .Orientation = xlPageField
        .Position = 1
    End With
    'Apply filter
    ActiveSheet.PivotTables("PivotTable3").PivotFields("On Report").CurrentPage = _
        "TRUE"
End Sub

Open in new window

0
I want to loop thru a folder with FSO similiar to the below code, however if the criteria is met
#1 I want to MOVE the item to a folder called OLD and
#2 If for some reason the file is open I do NOT want to attempt to move the file..so I assume I need to do an ONERROR prior to the move, but how should I structure my ONERRor ?


'Reference to Microsoft Scripting RunTime Library must be added
Sub FsoExample()
Dim fso As FileSystemObject
Dim srcFolder As Folder
Dim xlFile As File
Dim FolderPath As String

FolderPath = "C:\Test"      'Source Folder Path
Set fso = New FileSystemObject

Set srcFolder = fso.GetFolder(FolderPath)   'Setting Source Folder

'Looping through all the files in the source folder
For Each xlFile In srcFolder.Files
    'Checking if the file in the source folder is an Excel file
    If fso.GetExtensionName(xlFile) = "xlsx" Then 'If the Excel file has .xlsx extension
        'Do whatever you want to do with that file here
        'Say you want to open the file then try this...
        Dim wb As Workbook
        Set wb = Workbooks.Open(xlFile)
    End If
Next xlFile
End Sub

Open in new window

0
2 questions.

i just rolled out new office 2016 , ia m getting below errors

1) I made a customization to the ribbon in my new outlook 2016 . It was lost when I logged out of my session and logged back in it had reverted to the defaults.

Wanted to report that the “recent documents” tab is not populated in any office applications.
business users may expect to see the docs they last worked on in Excel 2010 in the recent tab in Excel 2016.
is there anything i can fix
0

Microsoft Office

66K

Solutions

41K

Contributors

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.