Microsoft Office

57K

Solutions

109

Articles & Videos

32K

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.

Refine results

Dear sir , i have a code, where it contains data , i need last updated time in a cell , so i have a formula, where it extracts date and time like this 23-FEB-2017 15:30:29 in one cell , but i need …

511 views
PRTG Network Monitor: Intuitive Network Monitoring
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

hi EE,

1. What is the best way to re-number column No (A) from 1 to visible rows please
2. e.g if I apply filter on Group1 with Yes rows. As it is now. in the sample file attached.
3. How to make…

618 views

Hi EE,
could you help with attached sample excel and how to achieve this please?

Basically
1. How to get Final Column (G) the Consolidated result using formula please?
2. If any one of the group…

57 views

Hi Experts,

    Curious if someone has a macro that will capture and notate ALL changes made to a workbook and then email out out those changes made to an email address or distribution list?  For …

314 views

Hello,

Does anyone know how to run PROPER (Propercase) on an entire Worksheet in Excel (Does ALL columns)?

Thanks.

313 views

I found the below code and it works, but it adds extra space to the column height.  How can I remove the extra space?

(CODE)

1211 views

Hi,

I am working on Microsoft word document with bunch of screenshots like log file dark screenshots with data. I like highlight a one of screenshot data with different color or or arrow or some …

724 views

I am attempting unsuccessfully to format data in Excel as a table from Access.  I was hoping someone could tell me what I'm doing wrong:

First way:
(CODE)

Second way:
(CODE)


Third way:

1112 views

Hi All

I have data in a spreadsheet that is exported from a guest Wi-Fi system.  Users are required to enter a name and email address, or use a social media account to use the free Wi-Fi.  That …

616 views

I'm struggling to hide a range of columns in another worksheet.  The closest I've got is this code but that only hides them on the sheet I'm on:

Private Sub Test2()
Dim sws As Worksheet, dws As …

2523 views
Netscaler Common Configuration How To guides
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Hi

I have an Excel 2007 workbook with macros in it. When I open the workbook I get the following prompt.
What I can't understand is the second message asking about links to another workbook …

612 views

Hi,
I cannot unhide columns, D, E, F, to the attached file. Why?

516 views

I have a csv file that only has data in column A. I have an excel workbook that I copy column A from the CSV to this excel workbook that I use to populate a mailing list. Problem is right now I am …

813 views

Hi guys what am i doing wrong? I get an error when trying to open the saved file again

this is the error i get:


this is the code:

(CODE)

1110 views

Hello,

I have a powerpoint with shapes that are linked to an excel file. Lets assume that the link is pointing at a range  in a sheet:

Sheet 1!R1C1:R5C2

When I insert a row on that Excel …

334 views

Trying to achieve this: Whenever helpdesk sends out an email to any user, the email displays at font: 16, colour: red and bolded.

To do this for 1000+ users in the org I imagine this could be done …

4108 views

I have a document  in Word 2013 (a book) which I already paginated. The page numbers appear at the bottom left and bottom right  (alternate) of the pages. I now want to simplify this and place ALL …

718 views

Hi,

I work on microsoft word daily. what are cool short cuts and tips on using ms word.

i have like 50 page document i go forward and backward and modify it.
any shortcut to move to top page …

337 views

I have a basic spread sheet.  I have attached a sample.

I would like to sum column c if column b has the word "Swings" in it AND the date in column a is between 1-1-2017 and 1-31-2017

I cant …

315 views
What is SQL Server and how does it work?
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Is there a process of creating an installer of Microsoft Office for Mac 2016 that you can install that will bypass signing into your Microsoft account and a way to insert an activation code into the …

338 views

I have a user that uses the same file repeatedly and only changes the text. She set custom margins according to the width of a border on the paper she prints on to. There are times she will open the …

1321 views

Hello.

I have a small business client running Exchange 2007.  They're about six months from going to Office 365.  They purchased a new desktop PC which came with Office 2016.  Outlook 2016 is not …

827 views

Hello, I am trying to configure email with a user on a new laptop.

The laptop had Office 365 on it
Then Office 2010 was added with outlook 2010
Then I had copied a profile over and and remove …

817 views

Hi guys,

I need some quick help again,

bmName is a variable that loops through Bookmarks, and I need to check that when bookmark "side1" or when bookmark "side2" is bmName then it should do …

1528 views

Hi,

I would like to find a closest match by comparing two columns in Excel. I tried VLOOKUP and MATCH but they return only if it is an exact match. Is there a way to find a closest match? I am …

747 views
Show more content
201506-LO-Top-001

TOP EXPERTS

view all

RELATED TOPICS view all topics

  1. Microsoft Excel
    (129,493)
  2. Microsoft Applications
    (43,173)
  3. Outlook
    (94,934)
  4. Microsoft Word
    (27,066)
  5. Microsoft Access
    (216,186)
  6. Visual Basic Classic
    (163,624)
  7. Exchange
    (196,674)
  8. Spreadsheets
    (6,015)
  9. Windows XP
    (118,278)
  10. Office / Productivity
    (5,016)