Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x

Microsoft Office

60K

Solutions

40K

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

Hey guys,
I have a client who is using Office 365 SharePoint online.  They want to know if there is a way to see who currently has a file open.  I have reached out to Microsoft Support about this and Microsoft themselves does not have a solution for this, but I was given some third party tools to try, but they did not seem to help.  I am wondering if anyone here has any ideas.  Thanks
0
What does it mean to be "Always On"?
LVL 4
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

I have a list of names and email addresses with the following format. How can I separate the names from the emails?

What I have:
Column A
Smith, Sue <smithsss@yahoo.com>

What I want:
Column B                       Column C
Smith, Sue                <smithsss@yahoo.com>
0
Hello,

We are on our way to a full migration from Office to GSuite here at my agency.  We are wanting to phase out Word and Powerpoint from our users but stil allow them to keep Excel.  Is it possible to utilize a group policy to push a silent removal of these 2 pieces of the software?  Is there a better way to do this?  Any help would be greatly appreciated.

Thanks
1
In Office 365 - Sharepoint online is there a way to deny SharePoint Administrator and Global Administrator access to a site collection?
0
I have a pick list of months  (January 2017, February 2017, March 2017)  and a corresponding table by month.  
Depending on what month I choose I want the data for that month to show up under the month that i have chosen.
( I can get it for January but not sure how to add if I pick a different month)
(see attached)

thanks so much
Kelly
1A.xlsx
0
I've encountered a rather strange problem that I could really use some help with. In a database that I've created, I've created some code that if an edit is made to one of the tables, it will send out an e-mail that will inform people of the change. The code itself has worked great in most of the databases, except for one. With that database, it causes an error upon reaching the specific line :

Set oApp = CreateObject("Outlook.application")

The error caused is Automation Error Library Not Registered 2147319779.
What really confuses me about this error is that the code is exactly the same as the other databases other than a few name changes for the queries it uses. Yet this one just doesn't work. I ran Office Diagnostics and it came up with no errors, and both Outlook and Access are the 2007 versions.

If anyone has any ideas about how to fix this problem, I would be really grateful.
0
Currently running on Prem Exchange 2010 and we deal with our clients daily. Operations likes to have a mailbox for almost every client that they can send email to and these mailboxes then get checked by 4 - 5 people. We grant them full access permission so it will show up in their outlook. My issues with this are the following:

1. Outlook takes a long time to open because of the amount of mailboxes that some people have access to.
2. We want to move to Office 365 but this could get expensive with the amount of general mailboxes we have.

My question is, is there anyone else out there who has or had this issue and what was their solution. I would really like to get away from this type of practice. Any help here would be great. Thanks!
0
I am using this code to take a query and save to a Excel template. What I would like is it not to save to the actual template but to a new excel file with a  different name so the template stays intact.

DoCmd.TransferSpreadsheet TransferType:=acExport, SpreadsheetType:=acSpreadsheetTypeExcel9, TableName:="qry_SectionOne", FileName:="C:\Test\Template.xlsm", Range:="SectionOne"
0
This code is working that colum AK is locked if AJ has a value and AJ is locked if AK has a value
AL is unlocked if either has “Other comment required”

Want to be able to lock AL if both AK and AJ are null

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.CountLarge > 1 Then Exit Sub

If Target.Column = 36 And Target.Row > 1 Then

    ActiveSheet.Unprotect Password:=PW
    If Target = "Other (comment required)" Then
        Cells(Target.Row, "AK").Locked = True
        Cells(Target.Row, "AL").Locked = False
       
        ElseIf Target <> "" Then
            Cells(Target.Row, "AK").Locked = True
            Cells(Target.Row, "AL").Locked = True
 
   End If
   
   ActiveSheet.Protect Password:=PW

ElseIf Target.Column = 37 And Target.Row > 1 Then
    ActiveSheet.Unprotect Password:=PW
   
    If Target = "Other (comment required)" Then
        Cells(Target.Row, "AJ").Locked = True
        Cells(Target.Row, "AL").Locked = False
       
        ElseIf Target <> "" Then
            Cells(Target.Row, "AJ").Locked = True
            Cells(Target.Row, "AL").Locked = True
       
       
    ActiveSheet.Protect Password:=PW

End If
0
I have been teaching a colleague how to create org charts on our own machines. When showing her how to rearrange subordinates,  each time she selects a subordinate pattern with the connectors on the left hand side 2 things happen:
1. the 1st subordinate does not arrange as the rest it's arrow is always bent and forms a different pattern into the manager
2. the distance from the connectors to the shapes is very large
However if she selects any patterns with the connectors on the right of the shapes she gets what I get, and what I expect, uniformity and a tighter space.
We are both using 2016. Please advise. This is her first introduction to Visio so her software is straight out of the box so to speak.
Any ideas gratefully accepted
0
Industry Leaders: We Want Your Opinion!
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

I have an owner of a distribution group, however when they try to add members they get the message to say that they do not have permissions do so.

This is an Office 365 solution, pure cloud so no on site servers or AD.

Is there a Powershell script to resolve this or any solution? Tried removing and adding, no joy.

Thanks

John
0
Hi All,
I am in need of your assistance with Excel.

I have an Excel spreadsheet with two worksheets, Shee1 and Sheet2

In Sheet1, I have the following columns
System
Table
Field
Field Mapped
Table Mapped

In Sheet2, I have the following columns
System
Table
Field

The differences between the two sheets is Field Mapped and Table Mapped in Sheet1

How could I populate Sheet 1.Table Mapped with text Y where
Sheet1.Table
match
Sheet2.Table  

Could this be done with a formula please? I am afraid I do not have access to VBA or to run macros due company policy.

This question is very similar to the question below
https://www.experts-exchange.com/questions/29057789/Columns-matches-from-two-seperate-worksheets.html

Many Thanks.
0
Hi ,
Please help me to create excel marco for attached excel sheet.
test.xlsx
0
Hi,

Setting up office 365 for a hybrid migration
Mail is to go through the on premise and get filtered through our firewall and mail appliance onsite.

I am a bit confused about the TXT and MX record and don't want to change anything yet until I am sure.
for now, what we have on O365  



      

MX      0      @      OURDOMAIN-com.mail.protection.outlook.com      1 Hour

TXT      -      @      v=spf1 include:spf.protection.outlook.com -all      1 Hour

CNAME      -      autodiscover      autodiscover.outlook.com      1 Hour



on our external DNS



domian.com.              3600      IN      MX      20 mx2.domain.com.
domian.com.            3600      IN      MX      10 mx1.domain.com.
domian.com.              3600      IN      TXT      "MS=ms########"




What do I need to change to get through the hybrid wizard to create the proper connectors to forward mail to On-premise mail server ?

thx in advance
1
Run into this issue where one of our users is listed in our local exchange as a contact but should be a under mailbox user and be office 365 mailbox.
 background:
We have office 365 synced with local AD. Have local exchange for mostly management . We have no local mailbox stores..
This one user is listed under contacts as a mail user but he is syncing with o365 no problem.

Any ideas how I can get this converted to o365 tag locally?
2017-09-20_16-40-52.jpg
2017-09-20_16-42-52.jpg
0
Using MS Word VBA, I have loaded items in a ListBox and I display it on a form. How can I find out what a user has selected and then close the ListBox? Does it require first adding an OK button for the user to click after making a choice? Is ListBox modal? Should I make a Do . . . Loop around the Form.show command? Right now, my code displays the ListBox and goes to the next line of code. I would rather it wait until a user has made a choice in the ListBox
     These sound like trivial questions. A couple days of searching the Internet suggest that anyone who uses a ListBox must already know the answers. I don’t.
     Thanks for your patience with a neophyte.
     JRA in Priddis
0
I had this question after viewing Module code needed to produce counts in new tab.  The code below works perfectly, but I would like to expand it so that it will sort with the highest count items on top.

I also want to be able to select more than one column to show next to the totals that should remain calculated only based on the first column selected.

As an example, I might select two adjacent columns and I would want that data (provided that the adjacent cells are just duplicate data on all like item numbers), to appear in columns C and D of the new tab next to the item count.

Sub CountItems()
Dim ws As Worksheet
Dim ColRng As Range
Dim Col As Integer
Dim lr As Long, i As Long
Dim x, dict

On Error Resume Next
Set ColRng = Application.InputBox("Please select a column to count items.", "Select Column!", Type:=8)
On Error GoTo 0

If ColRng Is Nothing Then
    MsgBox "You didn't select any column.", vbExclamation, "Column Not Selected!"
    Exit Sub
End If

Col = ColRng.Column
lr = Cells(Rows.Count, Col).End(xlUp).Row
x = Range(Cells(1, Col), Cells(lr, Col)).Value
Set dict = CreateObject("Scripting.Dictionary")

For i = 1 To UBound(x, 1)
    If Not dict.exists(x(i, 1)) Then
        dict.Item(x(i, 1)) = 1
    Else
        dict.Item(x(i, 1)) = dict.Item(x(i, 1)) + 1
    End If
Next i

On Error Resume Next
Set ws = Sheets("Count")
ws.Cells.Clear
On 

Open in new window

0
2017-09-20-13.01.07.pngEarly adopters of Apple iOS 11 are unable to send Microsoft-provided email using the native Mail app.

So I would hold off upgrade if this is important to you!

It affects Outlook.com, Office 365 and Exchange 2016 running on Windows Server 2016. Many businesses rely on Exchange and Office 365 for email.

Whoops.....Too late!
1
 
LVL 7

Expert Comment

by:Brian Matis
Gotta wonder how this ended up happening... iOS 11 was in beta for plenty of time...

Just did some quick checking and MacRumors is saying that there were bug reports on this during the beta:
https://www.macrumors.com/2017/09/20/apple-microsoft-email-server-issue-mail-app-ios-11/

Looks like Microsoft has some workarounds too. Either using Outlook for iOS client or disabling HTTP/2 in Windows Server 2016.
1
 
LVL 123
Windows Server 2016 has been a PITA as well as Exchange Server 2016!
0
From Windows 10, I need to objectivise each open window for Office and Non-Office Applications, and extract the active file name contained by each.

I am making automatic screenshots, and need an automatic record of the file from which each shot is taken. This is practicable if I can control which Application window(s) are open when the screenshot is taken. If the application windows are objectivised, I can close them, or minimize or hide them, as required.

The attached file contains code for two different approaches that do not get me all the way:

The first (GetWinInfo2) gets me all top level Window handles, including all application windows and their active filenames, but I don’t know how to sort them away from a large number of irrelevant handles, for buttons and other interactive processes. So I cant attempt to objectivize these windows from their handles.

The second approach (Task_Manager_Process_List_To_Sheet) does NOT return the current file name for each application, but only Names like ‘Chrome.exe’; ‘Excel.exe’, etc. No handle data is included.

I’m not v experienced with API calls, but have made a start – I ask for some pointers:
-       Am I on the right track?
-      How to tell which window handles are for Application windows.
-      Code that inputs a window handle and returns a window object.
-      Whether the taskmanager approach (which restricts itself to applications) can be induced to yield respective file names (as they appear in the Task Manager)

0
[Webinar] Lessons on Recovering from Petya
LVL 10
[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

I'm wondering what the maximum number of Email signing certificates is for Outlook 365. I've got 6 email accounts (some work related some personal) that have Comodo certificates for them. I have the new certificates here and can get 5 of the 6 loaded to Outlook. All 6 are in the Personal Certificate Store. I load the 6th and it seems to work it just doesn't appear on the list as selectable to choose for the email address. Am I making some sort of basic error here or ??

I HAD 6 loaded prior to this and they expired on 9/15/17 so this used to work....puzzled to say th least as I'm seeing it on a WIN10 system and a 2016 Server both with all current patches etc.
0
Excel Find Distinct Values within Column and sum another column per distinct value
0
I have a cell password protected and locked. Is it possible instead of having the message that Excel has "the cell or chart that you are trying to change......" and put in custom message box?
0
Hi,

I am getting the below error while running a .bat file which is using a .vb script.

C:\Windows\System32\Daily Channel Inquiry Report.vbs(103, 1) Microsoft Excel: Sa
veAs method of Workbook class failed.

on 103 line I have this method - objExcel.ActiveWorkbook.SaveAs strExcelPath.

Please help me to fix this issue ASAP.

Thanks
Venkatesh.
0
Count the number each item appears in a selected column and produce those values in a new tab.

Column A of New Tab = Original Value (text or number)
Column B of New Tab = Number of Times Value Appeared

Assistance is greatly appreciated.  A sheet might contain as many as 15,000 rows.
0
I have previously received great assistance on the attached workbook.  I would now like to know how to make the scrolling window dynamic so that it adjusts as new rows are added to the end of the database and stops at the last row with data.

Thank you for your assistance.
NCCU---Contracts-Inventory-Listing-.xlsm
0

Microsoft Office

60K

Solutions

40K

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.