Microsoft Office

65K

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

Cannot remove filter in Excel 2010. The option it is grayed out. See attached file.
Cannot-remove-filter-in-Excel-2010.pdf
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!

After a table draw in the Microsoft Word of Office 2016, any two cell merge cells in the middle of the table, cursor can not be inserted into the merged cell and if the merge then any text in that cell is deleted. But this is not the problem in office 2013. This problem is only in Office 2016. The cursor enters the merge cells in Office 2013, but why is the cursor not entering the office merged in Office 2016?
0
Last Windows 10 & or Office 2103/2016 auto update on powering down has caused the following issues:
0
Outlook makes appointments private when dragging to a delegate calendar on the outlook.
0
I'm a current office 365 subscriber interested in purchasing more One Drive for Business storage space (above the 1TB limit that I currently have) to store Veeam Server 2016 backups in the cloud.

What website resources are available that describe how much more it will cost to purchase additional Office 365 One Drive for Business storage space?
0
I need to read  a number of comma delimited csv file from a specific folder and put each file into a worksheet with the name of the worksheet being the name of the csv file.  How do I do this using Excel VBA?
0
Excel has data in columns A and B. Either columns can have blank and duplicates.

What is the fastest code that can find the number of unique matches between them?
0
Two emails accounts (user a & user b) have been migrated to Office 365. They can send the emails to all users on their on-premise Exchange server with the exception of one user (user c).  

The Office 365 users said the log files show the email has been delivered but user C cannot see them in the outlook box. He looked at the email on the server using OWA and the emails were not there either. This is only impacting this user on-premise. Other users are receiving the emails.

I also confirmed that the Office 365 users are getting delivery receipt.
0
I am sorting the status of a job as Loaded / Unloaded based on the text within the cell. What i need is to have a macro button installed which when pressed should read the cell value in  the status column and if it finds "Loaded" in column "S" then move the entire row to a different workbook (lets call it workbook2). Upon the transfer of the row of data it will delete from the current sheet. Workbook2 will have  two sheets for the sorted data - one for loaded and one for unloaded. An important feature of this code is that workbook2 already exists and therefore this macro will just need to open this notebook and save / close once the rows have been transferred.

My intent is to use this macro command button as an archive button to export the data from the current file to the next available row in  workbook2 (a pre-existing workbook).
1
Hi
I am looking for an excel function or combination of functions to find out unique number of values by names. Also, i need to add a criteria in the function. Ie where some other field  only with blank cells.

Hope you understand. I can upload a file if you want to.

Thank you
A
aa.xlsx
0
Python 3 Fundamentals
LVL 12
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 EE!
In Office 365 there is MS Teams and within there is a plugin for Outlook that allows the scheduling of Teams Meetings. Everything was working fine and able to schedule a meeting and such, but recently in random users Outlook the plugin drops off and is not able to be added back in. I have the .dll's in the correct place, I start Teams before Outlook, I run Teams as admin, and yet the plugin will not populate on the ribbon. Any suggestions to try and I will give feedback as such. Thank you in advance!
0
Hello,

I have the following procedure which allows me to replace values based on config sheet.
I would like to add the procedure to my personal.xlsb with the following requirements:

1-Add msgbox (yes, no) which says “Have you already created config sheet?” vbCtrl
“Sheet Name: Config-Replacement” vbCtrl
“Column A values to replace” vbCtrl
“Column B revised values” vbCtrl
“Column C reference column in which are located values to replace” vbCtrl
“Column D sheet name in which replacement procedure should be applied" vbCtrl
“Column E flag value: 1 for exact values” vbCtrl

2-If vbno is activated the config sheet reported in my example should be created with format and
headers. Else Run the replacement procedure
3-If vbno is activated and config sheet already exist. Exit sub and display msgbox which says “Config sheet already exist."


If you have questions, please contact me.
Replace-values-based-on-config-shee.xlsm
0
Hey guys,
I am wondering if anyone out there knows of a way to change which account a contact is syncing with on Iphone?  The situation that I am in now is that I have a user who is a delegate to the CEO of this company.  She has both her email as well as his email added to her phone. She put a personal contact in and it synced to the CEO's phone.  She also expressed a concern about losing her contacts upon leaving the company after her email is removed.  She also does not want to turn off the contacts for either Office 365 account as she wants to be able to look up contacts for the CEO as well as for herself.  Basically we want to be able to do have these people create their own personal contacts that do no sync with Exchange accounts, while still being able to download the contacts from Exchange and work with them, which I don't think would be unreasonable, but I cannot seem to make that happen on Iphone.  

Does anyone have any suggestions?
0
Hi

I have been asked to build a solution that saves documents and messages emailed back and forth in Outlook into some sort
of repository that can then be accessed from anywhere. I am looking for suggestions on the best way to do this using Excel/Outlook/Access VBA code, ASP.net webforms  and SQL.

My initial thoughts were to automatically send a copy (CC) message of all Outlook emails to an email address set up specifically for this as a starting point
then either store the documents on the company cloud server or in an ASP.net folder or SQL database.

Thanks
1
I am using Exchange 365:

- I can reset users password in office 365 through the web portal. Then I have to manually change the password in outlook 2013 settings.
- Is it a better way of doing this, because I have 200 user that used outlook 2013. (basically when I change the password in Office 365, I want it change in outlook automatically)
0
Hi

I installed office 365 on a RDS server straight after I installed the box - unfortunately while the regional settings were on their default US setting, I usually change to UK. Now every user that logs on has default paper size as Letter instead of A4, every printer does the same. How can I fix this?

I have changed the RDS server now to be UK region but any new user still gets created with US settings. There are 15 users set up on this system and, although not in production yet, I have logged is as every user and set up their profile and they have the US setup.

Can this be fixed if I delete every user profile, uninstall and then reinstall office 365?

Thanks very much.

Alasdair Barclay
0
hello, I'm trying to paste a value with "Match Destination formatting" but this option is not available or gray.  any idea please?
0
I have an on-premise exchange user setup in outlook and I have a different Office 365 user setup in Skype on the same computer. Every time I open Skype client I get an error "Exchange needs your credentials. Until then, you might see outside info in skype for business"

I believe this is because outlook and skype have different account. I tried to disable the "sync contact info between skype for business and exchange" in the skype setting but did not work.

skype.PNG
0
Hi Experts,

Hoping someone can help me with a solution to automate a manual daily task
I need top download a file from a http (url - report server) site and save it to a folder at regular intervals ( hourly )

The manual process is as below
1) Go to the website/url using IE
2) Click on a drop-down item and select "Export to Excel"
3) A pop-up appears to Open or Save the .xlsx file
4) Click on Save button
5) Save  it to a folder location on my pc.

I cant use any 3rd party tools or software as I cant download it due to restrictions in my organisation.

Preferably excel/vba solution or if there is an inbuilt windows solution to capture and record actions above and then schedule it at regular intervals.

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

Can someone tell me how to remove the original MAK license? The server wants to use the MAK license rather than the KMS license until I use ospp command to register the kms license then everything is ok - Thank you



C:\Program Files\Microsoft Office\Office16>cscript ospp.vbs /dstatusall
Microsoft (R) Windows Script Host Version 5.8
Copyright (C) Microsoft Corporation. All rights reserved.

---Processing--------------------------
---------------------------------------
SKU ID: ################################################
LICENSE NAME: Office 16, Office16StandardVL_MAK edition
LICENSE DESCRIPTION: Office 16, RETAIL(MAK) channel
LICENSE STATUS:  ---UNLICENSED---
ERROR CODE: 0xC004F014
ERROR DESCRIPTION: The Software Licensing Service reported that the product key
is not available.
---------------------------------------
SKU ID: ###############################################
LICENSE NAME: Office 16, Office16StandardVL_KMS_Client edition
LICENSE DESCRIPTION: Office 16, VOLUME_KMSCLIENT channel
LICENSE STATUS:  ---LICENSED---
REMAINING GRACE: 179 days  (259031 minute(s) before expiring)
Last 5 characters of installed product key: #####
Activation Type Configuration: ALL
        DNS auto-discovery: KMS name not available
        KMS machine registry override defined: agcnwksvcs:1688
        Activation Interval: 120 minutes
        Renewal Interval: 10080 minutes
        KMS host caching: Enabled
1
We have a file that was updated on the server.  It's an Excel spreadsheet.  The file date shows 9/18/18.  If I open the file on the server or at most users desks, it shows the updates recently done (we have the last user who modified the file put in a footer with their initials and the date they modified the file (9/13/18).
There are 2 users that, when they open the file in Excel (local copy), it shows an older version of the file (the initials inside the file and the date are older).  The date on the file from their Windows Explorer shows as 9/18/18 = correct.
I can't find any way for them to open the correct file.  It shows as the same file but once open - its the older version.

All the users are using Office 365 = currently Excel 2016
All users are running Windows 10
I clear caching folders - ones I could find on the users' local computer
I ran an Office online repair as opposed to the quick repair
I ran Windows updates - there were updates but non fixed the issue

I'm stuck
0
Hey guys,
I have a user who says that sometimes when moving an email to  a different folder the mouse pointer grabs one of the folders and then as a result she accidentally ends up moving one folder into another instead of an intended email.

She has never been able to recreate the issue for me when I was working with her.  Has anyone heard of this happening?  If so any solutions?
0
tally_duration.xlsxtally_duration.xlsxI have a raw data set that includes hourly pH values at multiple sites ("Sonde_Names") for two three-month periods: one in year 2013 and another in year 2014.

For each of the "Sonde_Names", I need to generate a list showing the number and duration of events where the pH is below a value of 5.5 (the field "BlwThresh" indicates which records are below 5.5). An 'event' is defined as one or more contiguous values of 1 in the "BlwThresh" field. This list also needs to include the associated values for "Sonde_Names", "Year", "Month", "Day", and "Hour", in which the event began.

(If possible, the "Event_num" field should reset to a value of 1 when starting to process each unique set of "Sonde_Names" and "Year" values.)

The worksheet named "tally_duration" shows a few manual examples of the objective.

Many thanks in advance for a (hopefully portable) automated solution.
0
Some time back we placed a question on how to read data from an internet page and save the specific content to an excel workbook (maybe it was a VBA).  We tried to search it in EE but can't find it.  So hope we can get the answer again.  We have certain web pages that we need get a specific data and save it's contents to an Excel.  For example, a user logs into a specific web page and register his work on it.  If a non-user views it, it always present the last user who saved his entry.  We want to read that user name and save it in the excel workbook.  The user name will always be in the specific location.  What is the best and automated manner in pulling data from a website into Excel?
0
Hello experts,

I would like to create a procedure to create multiple folders based on path reported in column A.
If folder cannot be created skip cell and continue to next one.

I have initiate the first part.
Could someone help me to finish the rest of the procedure and add the error conditions?
I attached example file.

Thank you very much for your help.
Create-folders-based-on-column.xlsm
0

Microsoft Office

65K

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.