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

x

Microsoft Applications

44K

Solutions

38K

Contributors

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Share tech news, updates, or what's on your mind.

Sign up to Post

Hi,

I have a Excel formula problem, my Excel formula knowledge is not good. Please refer to my attached JPG file.

Thomas

What is my error on cell F2? I want to get a result (IF cell A2 = "AA" , E12 will X L1. IF cell A2 = "BB" , E12 will X L2. IF cell A2 = "CC" , E12 will X L3.)

Regards,
Thomas
0
10 Tips to Protect Your Business from Ransomware
LVL 1
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

[b]SYSTEM[/bt
Asus T100 10" Laptop
Windows 8.1
Foxit PDF Editor/Reader
AutoHotKey Software

BACKGROUND
When using Foxit PDF reader, I need to magnify the document's text. This means I must scroll or pan left and right to view all the text. Foxit does not have any keys to pan left and right. I would like to use the Left and Right Arrow Keys to pan left and right when using Foxit.

PROBLEM
Can someone help me to assign the desired behavior to the Left and Right Arrow keys by remapping the keyboard? Can you help me write the script using the AutoHotKey software? If you have another solution that works, I'd like to know about it as well. Can the remapping be in effect only when in Foxit?
0
SYSTEM
Windows 8.1
Asus T100 10" Notebook

BACKGROUND
Foxit PDF Reader (Free Version) 9.3
In order to use the keyboard shortcut to pan left and right, when the screen is zoomed in, I had to disable Windows Hot Keys so that CTRL+ALT+ARROW would not rotate the screen. (My previous EE post focused on that problem.)

PROBLEM
Is it possible to assign a different Hot Key combination (other than ctrl+alt+arrow) that allows you to scroll (or pan) left or right in Foxit? Can you assign just the Left and Right Arrow keys without the control keys? That makes it so much easier to use the arrow keys to navigate the page with one hand.
1
On my work computer w/Windows 10, when I open Task Manager, the computer hangs.
0
MY SYSTEM
Windows 8.1
ASUS T100 Notebook (10 inch screen)

BACKGROUND
The problem I am trying to solve is difficult to search for on Google.

Problem (1): (SOLVED)
I need a magnifying glass app to enlarge the font on my small screen.
> > > > The native app that comes with Windows 8 is adequate for this issue.

Problem (2): When I read a paragraph that is enlarged, the text overflows out of the magnified reading area. This can be text in a PDF reader, text in a Word document, or text in the browser. (These may not be only text but text plus images, usually.)
 
QUESTION
Can you help me find a tool or utility or application (.exe) that runs on the Windows Desktop that will re-flow the paragraphs of a page so the text does not overflow the viewing area (allows it to wrap, perhaps) when either using the zoom feature (such as two finger gesture) or a magnifier?
0
conditions
1) both  the files are located in same place i.e.    C:\Users\Sholtan\Desktop
2)vba code will be placed in analyser.xlsb
3)Important  xlsx file name may differ
steps
1)open xlsx file
go to U column
apply the formula as shown in the xlsx file
2) go to V column
apply the formula as shown in the xlsx file
and save the xlsx file and close it
Analyser.xlsb
1.xlsx
0
Convert Csv file to xlsx and delete that csv file
Condition=
1)Both the files are located in same place  that is C:\Users\Sholtan\Desktop
2)the name of the csv file may differ
3)My vba code will be placed in Analyser.xlsb
1.csv
Analyser.xlsb
0
One of our clients is running an application under APP-V. Their app invokes our ActiveX Client which is essentially a container for an IE browser control; the webpage that occupies it carries a link that executes "window.open" (jQuery). Users are reporting 'Class not registered' errors.

I've seen a plethora of 'solutions', e.g. re-registering DLLs, running SFC, checking APP-V setting Allow All COM objects to interact with the local system, but no luck yet. This is on Win7 and Win 10 machines. Alas, I have limited knowledge of APP-V.

This error does not occur outside of APP-V.
0
I need help with VBA that is automatic "like worksheet change event" that if all of the rows for column result in zero then hide the column. otherwise unhide all column where one or more rows has value other than zero.

I have attached example file.
0
How do I convert the data below using a pivot table. If this can not be done with a pivot, then what is the fastest VBA code that can do the same thing.

BEFORE

     A          B
Tommy    98
Tommy    90
Tommy    22
Larry        12
Larry        99
Billy          52
Joe            34
Joe            55
Joe            67
Joe            96


AFTER

Tommy   98   90   22
Larry       12   99
Billy         52
Joe           34   55   67   96
0
Exploring ASP.NET Core: Fundamentals
LVL 12
Exploring ASP.NET Core: Fundamentals

Learn to build web apps and services, IoT apps, and mobile backends by covering the fundamentals of ASP.NET Core and  exploring the core foundations for app libraries.

what would be some useful checks to include in an audit/health check of SharePoint (and document management in general). The obvious one we can think of is around permissions of documents stored in SharePoint, to ensure sensitive documents are only accessible by the approved users/groups - but I wanted to spread the review a but further, and was hoping for some inspiration on what above and beyond security permissions would be useful when looking at such a system (it doesn't have to all be about security). Any common SharePoint mistakes/risks above and beyond permissions also most useful,
0
I'm looking for software that will allow me to use a key combination or method to launch software such as Google Chrome minimized.

For example, while I am using my Windows 10 laptop (with only the built-in LCD display, while it isn't connected to an external monitor) I will click on a link within an Experts Exhcnage email within Outlook 2016 and Google Chrome will then launch maximized. I would like a way of quickly being able to set Google Chrome to launch minimized so that these Experts Exchange links will launch and then when I am ready to read them I can click on the Google Chrome icon in the taskbar to maximize Google Chrome.

This will also be helpful when either opening other file attachments (such as Microsoft Office file attachments within Outlook or files within Windows Explorer).

Being able to press a certain key combination or enabling this setting and then disabling it when I don't want this to be done will be very helpful.

What applications, utilities or methods will allow this to be done?
0
I am looking for a method, utility or website to list how many times specific words are used in a Word document.

For example, I tend to overuse the word "Perform" when there are other suitable synonyms that can be used instead of "Perform."

So I am looking for a way of analyzing a Word document (or by copying and pasting the text) to give me a complete list of which unique words were used and how many times each word was used so I can discover trends in my writing and words that are being overused and can be replaced by synonyms to make my writing less monotonous and to give more variety and make my writing my descriptive and prolific.

I will gladly pay for such software or service that will allow this to be done.

What are the best ways of doing this?
0
How can I include the file contents contained with my Windows 10 Box Drive folder in Windows searches?

I am using the default Windows 10 Box drive folder location of %userprofile%\Box.

Currently whenever I search for files within Windows Explorer the files contained within Box Drive aren't included in this search and even if I go into the Box Drive folder (which is C:\Users\djones\Box on my Windows 10 computers) and perform searches for these files using their exact or partial files names these files ARE NOT listed in the search.

I have the Windows Search configured to include ALL folder locations on my computer's C: drive but when I look at the folder structure within the Windows search I see that the Box Drive folder of %userprofile%\Box (which on my computers is C:\Users\djones\Box) is NOT included.

So currently I have to log on to my Box account within a web browser to perform these types of searches.

How can I fix this so that when I perform searches the contents of the Box Drive folder WILL BE INCLUDED?
0
I can connect to my remote apps and run them locally but not outside of our network. Gateway server cannot be accessed when trying the run the app. Before it was my certificate didn’t match but I don’t get that message anymore.
0
To remove duplicate line if this line is based on a repeated route and also add 'Y' in column F to indicate that the next line was removed.

One can filter column b, c and d to be all equal to 0 and will see all the same route appear in column A.

See attached for detailed examples and comments.

And of course if there are more than 1 duplicates meaning like this:

108.004.600 - 108.004.600      0      0      0      84.75291788  
108.004.600 - 108.004.600      0      0      0      1.968908303  
108.004.600 - 108.004.600      0      0      0      2.417233924  
108.004.600 - 108.004.600      0      0      0      1.713124927  

then the result should be like this (3 lines below are removed) :
108.004.600 - 108.004.600      0      0      0      84.75291788   Y

and column G states how many lines were removed.

if there is no duplicate, for example:
405.091.200 - 405.091.200      0      0      0      6.337535366

then do nothing for this line.

Same concept applies to all.




Thanks !
Row-Indicator-Remove-Duplicate-EE.xlsx
0
What is the best way for me to copy and provide to another employee a full email folder that they can actively use? Is it a PST? Or, is there a better way? I have quite a bit of info on email that I need to share with others for their active ongoing use before I leave the organization in a week.
0
Has anyone had experience on converting PDF files to Visio 2016?  I lost my folder that had all my Campus Visio Diagrams but have the PDF versions.  Any help here would be appreciated.
0
Search Values in Excel worksheet

I have 2 Excel worksheets, they are the same. I mean same column names

on Worksheet 2 I would like to compare each row based on Column A with all rows of worksheet 1 and see if it exists

exmaple:
worksheet1 has a column A

Column A

awcds
mkhgc
fgtyol
etc..


on Worksheet column A
hgbnht
pppp
ggtg
mkhgc
jhtyu

I want the code to grab the first data of column A in worksheet 2 and look it up on Worksheet 1 Column A if it finds it it will write for instance on column P of worksheet 2 how many times it found that Data in Column A Worksheet 1

Thank you
0
Protecting & Securing Your Critical Data
LVL 1
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

Wanted to get the abbreviated month name based on a date.

In column J is the date and in columns N,O,P I wanted the abbreviated month listed based on the year.  

Please see attachment for example.
C--Users-lfreund-Documents-MONTH---.xlsx
0
We recently upgraded our SCCM clients (Configuration Manager) to 5.00.8634.1814.

We did this after upgrading the site to 1802.

After the upgrade all of the icons in Software Center are wacked out.  Prior to the upgrade, something was taking different sized icons and make them automatically appear the same.

In the new version, this functionality works in the List View option - all icons appear the same size regardless of their size.  In Tile View, which everyone uses, this is not the case.  The icons are not being adjusted for the view.

Has anyone else noted this issue?  Is there a setting somewhere I can click to resize?

I hope so.  So far it's that or I have to resize them all manually.
0
How To:  
  1. Create a Desktop or Taskbar icon for the online version of Microsoft Word 365
  2. Make .doc & .docx file types open Word 365 online

Summary
I have lost Word 2010 Starter (free, ad-based version offered on limited PCs & laptops) when I had to rebuild a PC.  One free option is to use the online version of Word in Office 365.  I am using it now, but all my Word files no longer have a default app.

Being able to open a program via icon or double-click on a file is a time-saver.  I'm not sure how to set this up, though, for the online version of Word or Excel.  Or Outlook, for that matter.

Help!
0
Ah hello.

This might be a simple question, but I am a C++ programmer by trade and don't know much about Excel.  So please bear with me :)

I am analysing a network packet trace and have extracted relevant data into the attached spreadsheet.  



Long story short, I need to automatically calculate values in the "A-S" column.  The pseudo-code for doing this is:

while we have not run out of rows
     while value in first column is an S
        remember the value in the VALUE column
        go onto the next row

        (At this point, the value in the first column for the current row is an 'A')
        Subtract the remembered 'S' value from the current row's VALUE
        Write this value into the A-S column for the current row

        Go onto the next row

Open in new window


I haven't got a clue how to do this.  Can someone please advise?
0
I use a Userform to setup an AutoFilter
How can I use the special cells, visible after the Auto Filter?
Obviously the attached code will refer to all data in the worksheet.
Can I adapt it so that it just focuses on special visible cells?

Dim LastRowA As Long, x as integer

With Sheets("Sheet1")
LastRowA = .Cells(.Rows.Count, "D").End(xlUp).Row
End With

For x = 1 To LastRowA
If Range("A" & x).value = 125 Then
'insert code here
End If

Next x

Open in new window

0
Hi guys,

My problem is the same as you have solved, but I use newer software. It was this issue:

https://www.experts-exchange.com/questions/25408602/Microsoft-Excel-opens-hyperlinks-with-wrong-program.html

I have Windows 10 Pro, MS Office Professional Plus 2013. For open dwg files I have set default association to DraftSight2018 x64 that works correctly for open dwg files from windows explorer. When I try to open hyperlinked dwg files from MS Excel, they are opened with Autodesk DWG TrueView 2017.

Well, I have read solution from mentioned topic, but I don't have such register HKEY_LOCAL_MACHINE\Software\Microsoft\Office\9.0\Common\Internet.

So, should I create the same ...Office\9.0... or should I create ...Office\15.0... according my MS Office 15.0 and Win10 or it will be totally different?

Thank You

Have a nice day

Jaroslav
0

Microsoft Applications

44K

Solutions

38K

Contributors

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.