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

I have the following environment
1.      Users “pc’s Win 7 with a GUI application is pulling and sends informational requests to an AS400.
2.      The pc’s are located in an office on the east coast New York, and the AS400 is in another office in the Florida. In the Middle is a cross connection router and firewall located in North Carolina.

Problem:
All Users in the Florida office using this application experience the following everyday and at least once day.

The user or users in the Gui application first receives a small swirling circle while in a transaction like the program is thinking !, and then receives this message from the program “ this program has terminated”.  This happens everyday.

>>What type of a problem is this, application or networking. And how do I resolve this. ?
0
How to Use the Help Bell
LVL 10
How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Hi all,
We are going to deploy Office 2016 (Currently using Office 2010) through SCCM 2012, what do we have to take into account before update process?
Also how does SCCM uninstalls the old office and installs the new one on the top? how does it differentiates between office32 bit and 64? and then install the right version?
Any articles and steps on how to deploy and configure it will be helpful.
Would installing office 2016 through SCCM would be the best way? or deploying it through Group policy will be better?

Thanks.
0
Hello,
I am aware that by setting up Out of the Office, incoming messages will be replied only once per sender, so as per Microsoft recommendation I have tried to setup rules instead. For some reason with rules, the auto reply still have the same behavior of sending the reply only once per sender. Below is the setup that I have tried out without luck.

http://support.savance.com/index.php?/eioboard/Knowledgebase/Article/View/214/14/setup-out-of-office-rule-that-replies-every-time

I am wondering if I am missing something or if there is some type of setting in Exchange server that I can enable/disable to auto reply to every message.

Any help will be appreciated.

Thank you!
0
I have been asked to reintroduce a local Exchange 2016 server to an environment that has already completed a cutover migration. All mailboxes are in the cloud and all local Exchange servers were decommissioned. They now regret giving up the Exchange management console for the simplicity of added an email alias or choosing to add/remove users from the GAL. They have Azure ADConnect in place for same sign on, so all changes must be made in local AD using the Attribute tab of the properties dialogue in AD Users & Computers. It is doable, but not exactly user friendly. Has anyone done this? I am not finding any information.
0
I have an excel worksheet as "lines" where I have to pick the data from each line and filter in Details tab and create pivot. below are the steps

1. if I have an 8 Digit number in column A ( in sample file it is in A1 and A8 copy and filter by that number in Details tab Column A
2. if there is a format like "12345.123" as in A2 A3 A4 etc., either do a text to column delimit by "." or take left 5 digits and filter in column C of details tab
3. take the 3 digits after "."(dot) and filter in column D of details tab

once filters are created do a pivot as shown in Pivot sheet I have attached a sample sheet
Book1.xlsx
0
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
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
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
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 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"
1
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
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 ,
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
Office 365 Training for Admins - 7 Day Trial
LVL 2
Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

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
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
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
Hi I have the following line of code in one excel cell
"01VINV20160229130801Jan 16 Incentive700120160101Incentive for Jan 16     GBP  
02VINV20160229130801Jan 16 IncentiveZP00655   20160101ZE07110          Incentive for Jan 16                              
04VINV20160229130801Jan 16 Incentive0000514060110          0            V0MWFS                              Jan 16 Incentive                                  "
 this is derived from the following formula:
='Copy of Payment file format'!A3&'Copy of Payment file format'!B3&'Copy of Payment file format'!C3&'Copy of Payment file format'!D3&'Copy of Payment file format'!E3&'Copy of Payment file format'!F3&'Copy of Payment file format'!G3&'Copy of Payment file

I want to be able to save to a text file so it generates 3 lines of data, is this possible?

thanks
Carl.
0
Hello experts,

Can anyone help me by providing the list of companies in aerospace industry, in an excel file, with a map chart included?

Thank you!
0
This has to be some simple setting, however, I have googled and googled to no avail. After I enter data into a cell and hit return, Excel underlines the entire row. This is not a new installation, just started doing this yesterday.
underline.docx
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.