Microsoft Office

64K

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

EA-Excel-test_master_28may2018--1.xlsxHello, I have an excel spreadsheet and I need help completing. Needs someone who knows VLookup, pivot tables, formulas and charts. Thanks.
0
The Ultimate Tool Kit for Technolgy Solution Provi
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

I have a user off-domain with a Microsoft E3 account. The user has the standard Office 16 suite.

I need to install Visio 16.

Where do I get the ISO or download the file, for the install?
0
Hello Experts:

In a previous post (https://www.experts-exchange.com/questions/29114146/Add-remove-trendline-to-Excel-graph-through-VBA.html?anchor=a42656598¬ificationFollowed=211366882#a42656598), I needed assistance with developing VBA code that would allow me to add/hide trend lines (via command button) to an existing histogram.
Expert Subodh has provided a superb solution that exactly does what I needed.

Now, I am requesting assistance with modifying the existing code (see attachment) where a single cmdButton allows to add/hide trend lines to all histograms on the worksheet.   Please see additional details in the attachment.

Thank you for your help in advance.
EEH
Command-Button-to-Add-Trendline-v03.xlsm
0
Doesn't Trim work within formulas?

I got a SUMIF like this
=SUMIF($A$18:$A$1006,A2,D$18:D$1006)

It looks like some of the text in the range $A$18:$A$1006 have trailing zeros! So they are not included in the SUMIF.
I tried this, but it doesn't like it
=SUMIF(Trim($A$18:$A$1006),A2,D$18:D$1006)

Why???? Isn't that just a nested formula?

Thanks
0
hello all,

We have machine with office and project volume licenses. Is there any possibility i can install office 365 project without uninstalling them.

we tried uninstalling project volume license and installing office 365 project didnt work. but it works if we uninstall office and project volume license and install office 365 project worked. Is there any work around?

Regards

AJ
0
I want to select the least date of each dates per month in a range.

e.g. My column A has dates

16Aug18
16Aug18
16Aug18
15Aug18
15Aug18
15Aug18
15Aug18
15Aug18
15Aug18
15Aug18
15Aug18
15Aug18
15Aug18
15Aug18
15Aug18
15Aug18
15Aug18
15Aug18
15Aug18
15Aug18
14Aug18
14Aug18
14Aug18
14Aug18
14Aug18
14Aug18
14Aug18
14Aug18
14Aug18
14Aug18
14Aug18
14Aug18
14Aug18
14Aug18
14Aug18
13Aug18
13Aug18
13Aug18
11Aug18
10Aug18
10Aug18
10Aug18
10Aug18
9Aug18
9Aug18
8Aug18
8Aug18
8Aug18
8Aug18
8Aug18
8Aug18
7Aug18
7Aug18
6Aug18
2Aug18
1May18
16Apr18
15Aug18
15Aug18
15Aug18
15Aug18
15Aug18
15Aug18
15Aug18
15Aug18
15Aug18
15Aug18
15Aug18
15Aug18
15Apr18
15May18
15Aug18
15Aug18
15Aug18
15Aug18
15Aug18
15Aug18
14Aug18
14Aug18
13Aug18
13Aug18
13Aug18
13Aug18
13Aug18
13Aug18
10Aug18
10Aug18
10Aug18
9Aug18
9Aug18
9Aug18
9Aug18
9Aug18
8Aug18
8Aug18
8Aug18
8Aug18
8Aug18
8Aug18
8Aug18
8Aug18
7Aug18
7Jun18
7Jul18
7Apr18
6Apr18
6Aug18
4Aug18
4Aug18
3Aug18
3Aug18
3Aug18
2Aug18
2Aug18
2Aug18
2Jun18
2Aug18
2Aug18
1Aug18
1Jul18
1Aug18
1Aug18


I want to select the least dates for Apr, May, Jun, Jul and Aug
0
Experts:

In the attached XLS, I am using a command button to add trend lines to the graph.

I also have a 2nd command button ("remove trend lines").   I tried to replace the ".Add" with ".Delete" for all three series; however, that syntax throws an error message.

My questions:
1.   What is the correct syntax that will allow me to delete the trend lines from the graph.
2.   Also, I would like to *combine" the two functions into one... maybe through an IF statement indicating the following:

Pseudo:
If command button caption = "Add" then
add trend lines
Else
remove trend lines
End if

Open in new window


How can the above be accomplished?

Thank you,
EEH
Command-Button-to-Add-Trendline-v01.xlsm
0
Getting a new desktop PC. Win 10/64. On current PC I use MS Office 2010. Several questions:

1. Getting a new PC. Currently using Office 2010. I'm thinking of installing Office 2013 instead of 2016-Home-and-Business on new machine. I make heavy use of Outlook and have read that users have trouble transferring their Outlook data from a previous versions to 2016. (I thought it was just a matter of copying the old PST to the new computer to replace the PST created by the new install of Office.) My writing partner has 2013 and it works much like 2010. I'm wondering what I gain by getting 2016H&B; I wonder too about the efficacy of buying a five-year old version of Office instead of the most recent 2016. Cost is no issue. Ease of transition -  especially with Outlook data - is key for me.

2. If I get 2016H&B, what is the difference between the direct download and the key card purchase? Why is the key-card version marginally less expensive? Most of all, what happens if the program or parts of it crash and you have to reinstall? Or if one of the program's files becomes corrupted. There is no disk to pull it from.

Thx.
0
We have MS Word SOP's that require users to sign off after reading them.  The SOP text will be locked but their is a table the users fill out with their name will be editable.  

This document works fine on our local file server but I want to put this on Office 365 SharePoint so it will be accessible through the web for our remote workers.  

When I try this, the functionality is reduced where the Word app will be able to edit but the O365 web version of Word can't.

The Word documents were created by the same version of office Word 2016

I would also like users to be able to access these SOP's from their iPhone and be able to edit (sign off)

Is this possible?  It seems like an easy thing but Office 365 doesn't work as I would expect with sharing and editing.

Thanks in advance
0
Overview
 
We currently host AD on our own servers in our own server room and a second AD (set up with trust) on our remote network hosted at Rackspace. We want to move everything into the cloud. Including AD within the next 30 days.
 
We use Office 365 and our preference would be to ONLY use the Azure AD within our O365 subscription, however, we believe this may not be possible. We have detailed below our current network configuration.
 
We would like someone to
 
a)      Provide us with a list of options detailing pros and cons
b)      Once we have picked one of the options we would like someone to provide us with a detailed plan explaining how we implement the solution
 
Current Network Configuration
 
We have
 
1.      8 SQL servers
2.      1 File server
3.      3 servers and a SAN making a virtual environment hosting several machine
 
All servers are windows servers on 2008, 2008r2  and 2012
 
We currently use AD for
 
•      Local users authentication
•      SQL server authentication and user permissions
•      Windows server authentication (Windows 2008 onwards)
•      External user authentication – we deliver a remote Vb6 application to ‘00’s of external users using RDP who authenticate using our local AD
 
AD permissions on the above are managed via groups and at individual level.  We also use AD to manage our SQL server permissions and group policy to manage devices on the network.
 
We also have some servers with our hosting partner Rackspace
 
1.…
1
Cloud Class® Course: Microsoft Office 2010
LVL 12
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

I'm trying to set up a spreadsheet that calculates commissions, using a sliding scale. Frontwards is easy: Take the value of the sales. Use the base commission, and add it to the sliding commission based on a lookup on the bonus, based on the sales value. No problem.

But I'd like to also be able to do it backwards. In other words, I want to know that if I want to make $X commission, then this is how much I need in sales. But it has to factor in that same sliding scale. And I don't know how to manage that. I'm attaching the spreadsheet here.Commissions.xlsx
0
Hi There,

we are using several RDS session, they all work fine with office but one...
each time someone tries signing into office we get a script error ( attached)

as anyone seen this before or can help?

Thanks :DScript error
0
Hi

New Windows 10 systems e.g. Lenovo, are now delivered with preinstalled Office 365

You can't however go into Programs & Features to uninstall it because it isn't listed
I tried uninstalling it using the Microsoft Easy fix utility:  no success

I could uninstall the files manually but that seems a little messy

Does anyone have an easy way to remove this preinstalled Officer instance ?

Here is the file path to this Office installation :
C:\Program Files\WindowsApps\Microsoft.Office.Desktop.Excel_16040.10325.20082.0_x86__8wekyb3d8bbwe\Office16

thanks
regards
yann
0
I have 2 macros in this file. 1) to sort by comment colors, then ship date and 2) sort the certs bucket by ship date only. When I run the macro it runs it for the buckets with the exact cells I highlighted  when I created the macros. Currently every time I want to sort the other buckets by option 1, I have 5 steps which I thought creating the macro would eliminate that so I didn't do something correctly but not sure what. I want to be able to use a macro to sort any of the buckets by option 1 no mater how many rows are in the bucket. If you would also explain to me what I did not do correctly that would also be helpful. Thx You
FINAL-CERT-SUMMARY---MACROS.xlsm
0
Hi All,

I want to delete all the review comments in excel at once. I mean, I have multiple tabs and each tab has review comments, it is time consuming task to run through all the tabs and use clear comments option.

Can I get VBA to delete all review comments in entire workbook at once ?
0
sample.xlsxI'm very much a beginner with VBA. I've usually gotten away with solving my problems with advanced formulae and avoiding VBA in the past. However I don't think I can solve this problem without it - I've reached the limit of my expertise!

I have been trying to remove syntax which is appearing when I export data from a sharepoint site into an excel spreadsheet.

Each cell will have a "product" value, which can have multiple values. In Sharepoint the cell has multiple values such as: 1.1.1.3-Fruit, 1.1.1.3-vegetables, 1.1.1.3-sweets.
However (doing some searches I know this has been seen before) when it is exported from Sharepoint, the values look like this: 1.1.1.3-Fruit;#259;#1.1.1.3-vegetables;#260;#1.1.1.3-sweets;#261;#. The x.x.x.x references are a configuration management number which I need to keep, which stops me from just stripping all numbers in the cell.

I had put in a formula to do some substitution to remove the ";#" values and replace with " ", but this leaves the number behind. I'd then used nested substitutions to remove the 259, 260, 261, etc as well, but the limitation on how many nested substitutions prevents this working for all cells in the "product" column.

I thought about using a lookup table, but I this can only provide limited results as well, using Vlookup for example.

I've thought about trying to do a replace in VBA and replace all possible values with blank space (eg ;#000;# to ;#300;#), but not sure how to …
0
Hello. Hoping someone can point me in the right direction. We recently began experimenting with Sharepoint List integration using Sharepoint Online and Office 365. Since integration with Access Desktop Apps was built in, we started there. I have a simple SharePoint list for tasking that was customized to add a few additional fields. Periodically, while using vba to update the Sharepoint List, it will cause Access to crash. The Event Log references an ntdll.dll error and sometimes an ACEWSS.DLL error.

The list is very small, less than 300 records. We update the list several times a day without issue, adding, editing and deleting records from the list. 1 out of every 10 times it will crash. I have searched everywhere for resolution. I have tried 1) "Use Cache format that is compatible with Microsoft Access 2010 and Later. 2) Online repair of office etc etc. Has anyone run into this?
0
I am not able to see yesterday's email in my outlook 2010
do I need to reset my view or as I am sure I haven't deleted them
0
In Office 365, I know you can export .csv's manually to gather reports, statistics, etc.,  Is there a way to automate this via powershell or other means for all modalities; email, sharepoint, teams, one drive, etc?

What I'm ultimately looking at doing is doing analysis to determine if I can downgrade a license based upon usage, as well as some other metrics.

Thanks Experts!
0
Managing Security Policy in a Changing Environment
Managing Security Policy in a Changing Environment

The enterprise network environment is evolving rapidly as companies extend their physical data centers to embrace cloud computing and software-defined networking. This new reality means that the challenge of managing the security policy is much more dynamic and complex.

I'm trying to get the month abbreviation in a field on a form.  For example, if in a date field on the form I enter 6/1/2018 in the 1st field I want the 2nd  field to indicate "Jun", ( no quote marks)
0
* We are looking to generate a report type output. Again there are many pages we need to draw information from.
* We would like to add a button onto our Owner List that when pressed would generate the output at the top of sheet Device Report.
* We created a macro that extracts all the data but it really does not do what we want.  
* I have highlighted the information at the top and where we got it from the list below.
* I have added two pages one called "Start" and the other called "Finish" the pages of interest are between the Start and Finish.  I have been told that the pages can be arranged in any order. Also the Start and Finish pages are there for reference and can be deleted.
* On the individual pages there is a column called "Complete?", should that column contain the word "Wave" it is considered complete and should not be included when the macro runs, we only want non-completed items to be returned.
* On the "Device Report" page that gets generated they would like to input the "Maintenance Window" Information and possibly be able to write it back to the page and row it's associated to.
* They would also like to update the "Notes" back to that page like the "Maintenance Window"
9K-Tracker-8.16.18-V2.xlsm
0
Hello Experts - I run a small IT department and we're planning on migrating to Office 365/hosted exchange next year.  I've been administering Exchange 2010 in house for several years and have a good understanding of how it works, but I'm a novice when in comes to Exchange online.  I'm looking for a good book or resource I can use to get up to speed prior to this upgrade.  I'd very much appreciate any recommendations on where to start!
0
i have to create a distribution group mail enabled.

we have on premise AD accounts are synced through AAD sync to office 365.

so will i be craeting distribution group in on premise AD?
0
I am attempting to setup Rest API in VBA and need some help walking through the steps. Can anyone help me by walking me through step by step for that I can learn how to do this for future projects?
0
Wanted to populate dates on another sheet based on date that is entered in anouther sheet....for example:

on tab Expense_Report at cell I7, I entered 8/11/2018 it will populate 8/17/2018 at cell J7 but I want to accomplish is on Tab Expense_Summary at cells B6:B12 the dates would be populated from 8/11/2018 on B6, 8/12/2018 on B7, 8/13/18 on B8 and so on to 8/17/18.

So everytime I change the date at cell I7 at th Expense_Report Tab it will adjust accordingly at the Expense_Summary Tab.  Please see attachment.
C--Users-lfreund-Desktop-Lucho-TTE-.xlsm
0

Microsoft Office

64K

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.